Returning text that will be a formula ...

[David Evans]

I want to return the text from E8:E13 that corresponds to FALSE in the respective columns Desired answers are in B2 And C2

Tried using SUMPRODUCT but kept getting a #VALUE# - it's late on Friday and I'm fading fast ... I know it's easy, but not for me ....

Oh and a further request - any way other than Offset to return the values i have on Sheets Accounts from Assets where the columns are not aligned, but are every other ...

Thanks!

 

[NARAYANK991]

Hi David ,

Does this not work ?

=VLOOKUP(FALSE,$B$8:$E$13,COLUMNS($B$8:$E$13),FALSE)

=VLOOKUP(FALSE,$C$8:$E$13,COLUMNS($C$8:$E$13),FALSE)

=INDEX(Assets!$A$2:$G$10,,2*COLUMN(A$1)-1)

Narayan

 

[David Evans]

Ninja Narayan -
Thanks for your reply - I'm having my Friday evening medicinal Guinness, but will get back to you soon. Appreciate your help, as always.
D