Index Formula don't work..

[StephenL]

Hello,
Need some help on this
I had a excel file dated 3 yrs ago...with the formula:
=index(Data!B3:k78,match(B3,Data!B3:B78,0),3)) working perfectly when
open it. But when I used the formula on my new excel file, it is no
working, it show #N/A.
I try to use help session on this but couldn't get what i want.
Kindly help to explain the error...

Thanks

Stephen

 

[Dav]

If you put match(B3,Data!B3:B78,0) in a cell what do you get? As yo
are looking for an exact match (the 0) if it can not find one it wil
return n/A, which will the cause the index formula to return N/A

Regards

Da

 

[Bob Phillips]

Does the value in B3 actually exist within Data!B3:B78?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)