Index and Match
 

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 ?

Index and Match
 

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.



carl wrote:

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

Index and Match
 

How about this?

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



--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"carl" wrote:

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 ?