Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup problem
We have a workbook which has name in column b we have another sheet with same
names but column 1 has id# we would like to have those codes whatever we tried does not work no idea why here is our codes we tried =VLOOKUP(B1,[Book4.xlsx]Sheet1!$A$1:$C$890,1,TRUE) when we drag sometimes we get "MemberID" in the cell which is data from cell "a1" all other data is #N/A |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup problem
Read this VLOOKUP() tutorial:
http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "dk" wrote in message ... | We have a workbook which has name in column b we have another sheet with same | names but column 1 has id# we would like to have those codes whatever we | tried does not work no idea why | here is our codes we tried | =VLOOKUP(B1,[Book4.xlsx]Sheet1!$A$1:$C$890,1,TRUE) | when we drag sometimes we get "MemberID" in the cell which is data from cell | "a1" all other data is #N/A |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup problem
We think we found the error problem there are extrange characters in the
workbook how can we remove those "Niek Otten" wrote: Read this VLOOKUP() tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "dk" wrote in message ... | We have a workbook which has name in column b we have another sheet with same | names but column 1 has id# we would like to have those codes whatever we | tried does not work no idea why | here is our codes we tried | =VLOOKUP(B1,[Book4.xlsx]Sheet1!$A$1:$C$890,1,TRUE) | when we drag sometimes we get "MemberID" in the cell which is data from cell | "a1" all other data is #N/A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) | |||
VLookUp problem | Excel Worksheet Functions | |||
Vlookup problem | Excel Worksheet Functions | |||
Vlookup problem | Excel Worksheet Functions |