Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - can't figure out what's wrong
I've tried to illustrate my problem:
"NameID" is A1, "rs10170160" is B1, etc. Array data starts at A35 Name ID€¦..rs10170160 70001-1€¦..(formula here) Formula: =vlookup(A2&B$1,A$35:E$38,4,False) Array: (note, column C here is programmed in as =A35&B35) 70001-1€¦..rs10170160€¦..70001-1rs10170160€¦..C€¦..T 70001-11€¦..rs10170160€¦..70001-11rs10170160€¦..C€¦..T 70002-1€¦..rs10170160€¦..70002-1rs10170160€¦..C€¦..T 70002-13.....rs10170160.....70002-13rs10170160.....T.....T Why does my formula keep returning NA when it should return a "C"?? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Vlookup gives wrong answers when used in large data. Pls advise? | Excel Worksheet Functions | |||
If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
Vlookup data wrong if the small value found are same | Excel Discussion (Misc queries) |