LinkBack URL
About LinkBacks
I need a formula that returns the content of a cell if another cell equals yes if possible
So if Cell H1 = yes then I want it to return the Contents of D1.
Need a formula that returns a the content from a cell if another cell equals yes
I need a formula that returns the content of a cell if another cell equals yes if possible
So if Cell H1 = yes then I want it to return the Contents of D1.
Formula:
Please Login or Register to view this content.
Hope that helps.
Thanks,
Duncan
If this solves your problem, please click on the star, and mark the thread solved.
Formula:Please Login or Register to view this content.
Regards, TMS
Edit: corrected as per post #4 from duncandhu
Last edited by TMS; 09-20-2013 at 03:34 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This returns an error due to the single quote marks.Originally Posted by TMShucks
Formula:Please Login or Register to view this content.
Apologies ... you are correct ... what comes of typing on an iPad (and not thinking).
Mea culpa, mea culpa, mea maxima culpa
And, you know what, I actually compared our solutions as you'd beaten me to it! Just goes to show, you see what you expect to see.
Regards, TMS
self-fulfilling prophecy
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
@FD: what is?
Easy mistake to make! Don't be so hard on yourself!Apologies ... you are correct ... what comes of typing on an iPad (and not thinking).
Mea culpa, mea culpa, mea maxima culpa
What you said earlier...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks