Previous Topic Next Topic

Bring back a value (customer Id)

Closed
Grainne - Nov 11, 2015 at 01:32 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 11, 2015 at 01:47 PM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 11, 2015 at 01:47 PM
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