What excel function to use?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with Col A having unique customer numbers. Column D
also has the same customer numbers but in no particular order. Column E has
a unique value associated with the number in Column D. I want to have the
unique value associated with the same numbers in columns A & D placed in
Column B.
Is this possible?

Thank you
 
B1: =VLOOKUP(A1,&D$1:$E$100,2,False)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top