Forum Discussion
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#. Tabl...
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.