Forum Discussion

jamescosten's avatar
jamescosten
Brass Contributor
Jul 16, 2024

Vlookup between two tables not working.

I have the following FX:

 

=VLOOKUP([@ID],Table6[@ID],4,FALSE)

 

Table Im in is looking in another table for the ID calue and returning the 4th column value. Except it just returns N/A#.

 

Table with Vlookup: 

Table I want to lookup and get value: 

Both ID columns are Column A.

 

excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Jul 16, 2024

    jamescosten 

    I haven't used VLOOKUP for 10 years now (I went from INDEX/MATCH to XLOOKUP) but it appears to me that you are searching for the ID in a single cell of Table6.  Assuming the ID column is the first column, then

    = VLOOKUP([@ID], Table6, 4, FALSE)

    might work better.

Resources