I have four columns ABC&D A is where I want the formula, B is a list of 30 names, C is a list of 1000 ID numbers and D is a list of the corresponding 1000 names. Is there a formula I can put in column A that copies the ID number from C that corresponds with the name in column D that is a duplicate of the name in column B?
Move Column C to Column E. Then use the following equation and copy down:
=vlookup(B1,$D$1:$E$1000,2,false)
One way...
With your data starting on row 2.
Enter this formula in A2 and copy down as needed:
=INDEX(C:C,MATCH(B2,D:D,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you guys both of those formulas worked perfectly!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks