Index and Match

  • Thread starter Thread starter carl
  • Start date Start date
C

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 ?
 
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.
 
Back
Top