Index & Match

[phuser]

Im having a brain fart here, and cant see the error

the formula is in C4, A Column contains the match as well as BE, the number
in BF is currency

=(INDEX($BE$3:$CS$300,MATCH(+A4,$BE$3:$BE$300,0),2))

 

[T. Valko]

There's nothing wrong with your formula. You can get rid of the extra set of
( ) and the + sign but neither of those will cause a problem:

=INDEX($BE$3:$CS$300,MATCH(A4,$BE$3:$BE$300,0),2)

Alternatives:

=INDEX($BF$3:$BF$300,MATCH(A4,$BE$3:$BE$300,0))

=VLOOKUP(A4,$B$E3:$BF$300,2,0)

Possibly:

=SUMIF($BE$3:$BE$300,A4,$BF$3:$BF$300)

 

[phuser]

Thank you for your response Biff but for some reason it is still returning
the NA like it cant find the match
I tried all the recommendations but none work.

Pauline

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html#Trouble