LOOKUP and return the column heading for IF/THEN return for False
I am using the IF formula to return " " when the logical test is true but
wish it to return the column heading of the value if the logical test is false. |
LOOKUP and return the column heading for IF/THEN return for False
NN wrote:
I am using the IF formula to return " " when the logical test is true but wish it to return the column heading of the value if the logical test is false. Post your formula, so we can try to help you... -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com