Auto pick name if match cell value

[Suresh Badhani]

I have a data and have to select top and Bootom performer name if match criteria from as attached file.

 

[bosco_yip]

Try,

In F33, formula copied down, and formula copied to R33 & copied down :

=LOOKUP("zzz",$A$1:INDEX($1:$1,MATCH(E33,IF(ISERR(FIND("Not",$B33)),$30:$30,$31:$31),0)))

 

[Suresh Badhani]

Try,

In F33, formula copied down, and copied right to R33 & copied down :

=LOOKUP("zzz",$A$1:INDEX($1:$1,MATCH(E33,IF(ISERR(FIND("Not",$B33)),$30:$30,$31:$31),0)))

View attachment 77786

Thats working very very thanks but what is zzz in lookup

 

[bosco_yip]

Thats working very very thanks but what is zzz in lookup

"zzz" is refer to a very big text number, formula logic is to return the last text value within a range.

For more details, please Google "Excel Bignum".

Regards

 

[Suresh Badhani]

Realy great knowledge thanks a lot ❤ quick support.