software

I'm having a problem with a formula I'm trying to create. I have 7
different tests, lets call them A-G; that you can receive a 1,2,3, or 4
on. I want to create a formula that will identify what test and what
number was entered to kick back a value. So A-1 would have a different
value than A-4, likewise, D-2 would be different than B-2. I'm not sure
if this is possible to create a function of this length. If this would
be to long, are there any alternatives? Thanks in advance for the
help.--
DVV
------------------------------------------------------------------------
DVV's Profile: www.excelforum.com/member.php...oamp;userid=30561
View this thread: www.excelforum.com/showthread...hreadid=502105
I take it nobody knows --
DVV
------------------------------------------------------------------------
DVV's Profile: www.excelforum.com/member.php...oamp;userid=30561
View this thread: www.excelforum.com/showthread...hreadid=502105
If I inderstood your problem correctly you should use VLookup function.--
Irina
------------------------------------------------------------------------
Irina's Profile: www.excelforum.com/member.php...foamp;userid=8685
View this thread: www.excelforum.com/showthread...hreadid=502105
Possibly you can create a table on the side showing the possible
combinations in one column and the desired respective result in another
and use a vlookup to retrieve the desired result.

E.g.

Table in J1:K12
CodeResult
A1A
A2B
A3C
A4D
B1E
B2F
B3G
B4H
C1I
C2J
C3KIf I have these following entries, where A, B, C are the actual column
headers and the 1, 2, 3 are entries made by the user.

ABC
123Then a formula to use can be:
=VLOOKUP(LEFT(ADDRESS(1,COLUMN(A1),4),1)amp;A1,$J$1:$ K$12,2,0)
copied across the columns.

Note: This formula assumes you start entering the data in A1. Change
the cell ref in the Column() function and in the ref after the amp; symbol
to match the column you enter data in. Also adjust lookup range to
suit.

This formula takes the letter of the column address and combines it
with the number you type into the cell in the same column and then it
looks up this combo in your table and retrieves the corresponding
result.

For the example above, the formula would return

AFKHope this helps.--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=502105
Thanks for the help, I will definetly give that a try.--
DVV
------------------------------------------------------------------------
DVV's Profile: www.excelforum.com/member.php...oamp;userid=30561
View this thread: www.excelforum.com/showthread...hreadid=502105