LOOKUP and return the column heading for IF/THEN return for False

[Guest]

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.

 

[Franz Verga]

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