Hello,
I have a column (A) that has a list of names. Column (C) That has a longer list of names and column (D) that has a list of subnames that corresponds to column (C). In column (B) I want to read if the cell equals any name in (C) and if so, return what is in (D).
Sorry if it's confusing. My formula right now returns everything as false.
=IF($A1=C:C,D:D) ...that is in cell B1
Thank You
shnolan,
Welcome to the forum!
What you're looking for is the VLookup() formula. In your case, it would be:
=IFERROR(VLOOKUP(A1,C:D,2,0),"")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That did the trick, thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks