Index & Match formula on cells containing formula's

[pulsecoding]

Hi all,
I have formula INDEX($G$2:G5,MATCH(REPT("z",255),$G$2:G5)) which check the range g5 to g2 for string and returns it.
Earlier I didnt had formulas in the range g2 to g5 so this formula was giving me correct result.
now As I have formulas in the range g2 to g5 it is not returning the correct result.

the range contains formula IF(U5=0,"",VLOOKUP(U5,$IO$2:$IP$377,2,FALSE))

so when cell g2 contains a string and g3 to g5 contains blank returned from their individual formulas this index formula does not return string from g2 cell.

this index formula should return g2 cell string.

 

[Aladin Akyurek]

Hi all,
I have formula INDEX($G$2:G5,MATCH(REPT("z",255),$G$2:G5)) which check the range g5 to g2 for string and returns it.
Earlier I didnt had formulas in the range g2 to g5 so this formula was giving me correct result.
now As I have formulas in the range g2 to g5 it is not returning the correct result.

the range contains formula IF(U5=0,"",VLOOKUP(U5,$IO$2:$IP$377,2,FALSE))

so when cell g2 contains a string and g3 to g5 contains blank returned from their individual formulas this index formula does not return string from g2 cell.

this index formula should return g2 cell string.

That formula would indeed return the text value (a blank created with a formula) if that's the last value in G2:G5. If you want to ignore formula blanks, try:

=LOOKUP(9.99999999999999E+307,SEARCH("?*",G2:G5),G2:G5)

 

[pulsecoding]

That worked out correctly.

Thanks Aladin..!

 

[Aladin Akyurek]

That worked out correctly.

Thanks Aladin..!

You are welcome. Thanks for providing feedback.