Index and Match

[carl]

I use this formula:

=INDEX($B$6:$B$255,MATCH(1,--ISNUMBER(FIND(AE7,$C$6:$C$255)),0))

I appears to be returning the value in $B$6:$B$255 that corresponds to the
first instance that FIND(AE7,$C$6:$C$255)) is satisfied. However, in
$C$6:$C$255 I can have multiple cells that contain the "X" while AE7 contains
the value X, the formula will return the first place it finds "X".

Is there a way to modify the formula to do an exact match ?

 

[Dave Peterson]

Maybe...

=index($b$6:$b$255,match(ae7,$c$6:$c$255,0))

This won't distinguish between X and x, but it will distinguish between x and
asdfxqwer.

 

[Luke M]

How about this?

=INDEX($B$6:$B$255,MATCH(TRUE,EXACT(AE7,$C$6:$C$255),0))