Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function problems
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: http://www.excelforum.com/member.php...o&userid=30561 View this thread: http://www.excelforum.com/showthread...hreadid=502105 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function problems
I take it nobody knows :) -- DVV ------------------------------------------------------------------------ DVV's Profile: http://www.excelforum.com/member.php...o&userid=30561 View this thread: http://www.excelforum.com/showthread...hreadid=502105 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function problems
If I inderstood your problem correctly you should use VLookup function. -- Irina ------------------------------------------------------------------------ Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685 View this thread: http://www.excelforum.com/showthread...hreadid=502105 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function problems
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 Code Result A1 A A2 B A3 C A4 D B1 E B2 F B3 G B4 H C1 I C2 J C3 K If 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. A B C 1 2 3 Then a formula to use can be: =VLOOKUP(LEFT(ADDRESS(1,COLUMN(A1),4),1)&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 & 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 A F K Hope this helps. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=502105 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND Function problems
Thanks for the help, I will definetly give that a try. -- DVV ------------------------------------------------------------------------ DVV's Profile: http://www.excelforum.com/member.php...o&userid=30561 View this thread: http://www.excelforum.com/showthread...hreadid=502105 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linest function: data selection problems | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |