What excel function to use?

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
 
B

Bob Phillips

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

and copy down

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria to return maximum value where x = x 3
With F1 value, look at A, if match or partial match return B 5
Calculate total by row number 4
customer Name against Unique customer number count 3
Find MAX number with criteria 8
Largest value in Col B for each unique value in col A 4
What type of "lookup" 3
Lookup function 2

Top