Hello,
I need to assign the ID value to the cell in the source column when it matches the cell value in the email column.
i.e from the email column the first cell value is bobjohnson@email.com his ID value is 0 I need to find all the cells with bobjohnson@email.com in the Source column and assign them 0
Any help with this is appreciated
Thank you
Please Login or Register to view this content.Please Login or Register to view this content.
Assuming "email" is in cell A1, then in D2 (the first row of data)
=vlookup(C2,$A$2:$B$14,2,FALSE)
Drag that down. That should provide your source integers.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
For some reason I did not get a email update on this, Thank you Pauleyb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks