I have a spreadsheet with a bunch of account numbers in column A many of which are duplicates. In Column C i have the same account numbers only not duplicates. In column D i have passcodes for each of these account numbers.
What i basically want to do is lookup the account numbers in column C and copy the passcode from column D to column B if what's in column A matches up with the passocde on the same row in column C.
This is the formula i'm using in column B where i want the data to be.
Is there another way to accomplish this? =lookup maybe?=if(A2=C:C,D)
Try
=Vlookup(A2,C:D,2,0)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks