Hi Folks
In the attached worksheet I have set up Col D to return Yes/No
Where Col D does return "Yes" I want Cell C5 etc to return the value corresponding to the name from Cols E & F.
So RADISH returns "Yes" I now need the value (2) to appear in Col C in line with RADISH.
Where PUMPKIN returns "No" I want C6 to return blank.
Cheers
Hammer
Try this:
=IFERROR(VLOOKUP(A5,$E$5:$F$8,2,0),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You were a little unclear as to whether you wanted both cell contents returned?
If so, try this, copied down...
=IF(D5="Yes",E5&" "&F5,"")
If you just want 1 of the cells, adjust it to...
=IF(D5="Yes",E5,"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What a great Forum!
Thank you folks.
Happy to help and thanks for the feedback
Just curious, which suggestion worked for you, because they were both different interpretations of your question, with *almost* completely different answers
The first one thanks FDibbins.
Apologies for not making things as clear as they should be. I know what I want but am never able to express it clearly enough in writing (I plead old age)
Thanks for the update, and dont worry, even with sometimes detailed descriptions, different members will read it different ways, hence why I asked (I use that excuse too by the way lol)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks