Hi all,
I have a spreadsheet and wanting to put formula into cell (D1), which will only show if cell (C1) has a numerical value, if no value then nothing shows in cell (D1)
The formula I want to use in cell(D1) would have to have a vlookup as part of it.
Any thoughts would be much welcomed
use:
Formula:
Please Login or Register to view this content.
like:
etc.Formula:Please Login or Register to view this content.
Best Regards,
Kaper
If you would only ever have a numeric in C1 (and never text), then Kaper's suggestion could be shortened to...
=IF(C1="","",your_current_formula)
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
Thank you so much, works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks