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