jspc
asked on
V-Lookup
Hello,
I'm wondering if someone can please help me with a VLOOKUP in an Excel File?
I have 2 datasheets. Stock and Datasource.
I'm trying to reference the Sheet Stock Column J to the Sheet Datasource column b
Please see attached example.
STOCKFINAL.xlsx
I'm wondering if someone can please help me with a VLOOKUP in an Excel File?
I have 2 datasheets. Stock and Datasource.
I'm trying to reference the Sheet Stock Column J to the Sheet Datasource column b
Please see attached example.
STOCKFINAL.xlsx
ASKER
I'm getting #N/A
I have converted to number
I have converted to number
Na where is no corresponding reference
STOCKFINALv1.xlsx
STOCKFINALv1.xlsx
For convenience of writing the formula I have converted the lookup table to a Table.
The formula is then =VLOOKUP(A2,Table1[#All],2 ,0)
However, your codes do not seem to match. See the result when I type in a dummy code - Test1
STOCKFIN-1-AL.xlsx
The formula is then =VLOOKUP(A2,Table1[#All],2
However, your codes do not seem to match. See the result when I type in a dummy code - Test1
STOCKFIN-1-AL.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have added IFERROR to show if a code is missing.
ASKER
Thank you, however if I copy your change down it doesn't reference the barcode number in the Datasource sheet
Forgot the last attachment
STOCKFIN-1-AL.xlsx
STOCKFIN-1-AL.xlsx
ASKER
Thank you
Even this question is closed. Another approach would be to use:
STOCKFINAL_v1.xlsx
=IFERROR(INDEX(DataSource!B:B,MATCH(A2,DataSource!A:A)),"")
Please find attached...STOCKFINAL_v1.xlsx
The codes are definitely different, see the effect of matching codes from the main table with the Lookup Table, cells highlighted in yellow, the formula works
STOCKFIN-1-AL.xlsx
STOCKFIN-1-AL.xlsx
pls try
Open in new window
the first 2 cells in Datasource are text. pls convert to number to workRegards