What excel function to use?
 

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

What excel function to use?
 

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

and copy down

--

HTH

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


"Excel user" <Excel wrote in message
...
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