Link to home
Start Free TrialLog in
Avatar of jspc
jspcFlag for Australia

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
Avatar of Rgonzo1971
Rgonzo1971

Hi,

pls try
=VLOOKUP(A2,A1Range,2,0)

Open in new window

the first 2 cells in Datasource are text. pls convert to number to work

Regards
Avatar of jspc

ASKER

I'm getting #N/A

I have converted to number
Na where is no corresponding reference
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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have added IFERROR to show if a code is missing.
Avatar of jspc

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
Avatar of jspc

ASKER

Thank you
Even this question is closed. Another approach would be to use:
=IFERROR(INDEX(DataSource!B:B,MATCH(A2,DataSource!A:A)),"")

Open in new window

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