Bring back a value (customer Id)

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


I need to bring back a value (customer Id) into Column J if column A from that workbook and Column A from another workbook are a match. The id will come from the other workbook which is in Column C. This will bring back a customer ID and populate it into Column J. I know it is something like this:

=VLOOKUP(J1,MostRecentCompassExport!$C$1:$P$1,2,FALSE)
But it is just not working, what am I doing wrong?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
hmm pretty much every thing other than VLOOKUP and FALSE :)

VLOOKUP(J1,MostRecentCompassExport!$C$1:$P$1,2,FALSE)

J1 should be A1, as you want J column to be populated based on whats in A column

MostRecentCompassExport!$C$1:$P$1, 2 should be MostRecentCompassExport!$A:$C, 3