Index & Match
 

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 ))

Index & Match
 

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)


--
Biff
Microsoft Excel MVP


"phuser" wrote in message
news:Jdadnb1BqdkYFZrVnZ2dnUVZ_tWtnZ2d@sasktel...
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 ))

Index & Match
 

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" wrote in message
...
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)


--
Biff
Microsoft Excel MVP


"phuser" wrote in message
news:Jdadnb1BqdkYFZrVnZ2dnUVZ_tWtnZ2d@sasktel...
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 ))

Index & Match
 

See this:

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

--
Biff
Microsoft Excel MVP


"phuser" wrote in message
news:ZMCdnaIHh-X3XprVnZ2dnUVZ_vyinZ2d@sasktel...
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" wrote in message
...
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)


--
Biff
Microsoft Excel MVP


"phuser" wrote in message
news:Jdadnb1BqdkYFZrVnZ2dnUVZ_tWtnZ2d@sasktel...
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 ))

Index & Match
 

Well I think I understand what is causing the problem, I have imported the
data through micorsoft access, I have input some numbers manually and it
works just fine, but when I have used the import data, it returns the NA.
The original table that contains the data is "number" so I changed the field
for my match to number as well but it didnt help, the only solution I can
see working would be to copy & paste the data from the original table, which
kinda sucks all the atomation out of it :-(


"phuser" wrote in message
news:Jdadnb1BqdkYFZrVnZ2dnUVZ_tWtnZ2d@sasktel...
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 ))