Thread: LOOKUP and return the column heading for IF/THEN return for False
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
  
Posts: 459
Default 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


Reply With QuoteReply With Quote