| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP USING 2 LOOK UP VALUES
I am trying to use VLOOKUP for both columns A&B and I get the "#value!" error in the cell with the formula. This is the formula I am using: =VLOOKUP(A1:B1,table_array,3,false) If I use just column A: =VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result. How do I write this so I can lookup both A&B. Thanks A B C RA-2 20 0.14 RA-2 30 0.17 RA-2 40 0.2 RA-2 50 0.22 RA-2 60 0.24 RA-4 20 0.28 RA-4 30 0..35 etc. etc. etc.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP USING 2 LOOK UP VALUES
bpeltzer,
Thank you, I was able to make this work with your advice of combining the two columns into one and then using vlookup off the new column. "Jay Trull" wrote: I am trying to use VLOOKUP for both columns A&B and I get the "#value!" error in the cell with the formula. This is the formula I am using: =VLOOKUP(A1:B1,table_array,3,false) If I use just column A: =VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result. How do I write this so I can lookup both A&B. Thanks A B C RA-2 20 0.14 RA-2 30 0.17 RA-2 40 0.2 RA-2 50 0.22 RA-2 60 0.24 RA-4 20 0.28 RA-4 30 0..35 etc. etc. etc.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Vlookup with multi values | Excel Worksheet Functions | |||
| Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
| vlookup returning multiple values | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Hybrid Mode
