Why are you trying to match A1 against the first 3 chars of A1 (and 2 and 3
and 4)? It can only match if A1 is 3 chars.

--
HTH

Bob Phillips

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

"via135 via OfficeKB.com" <u23552@uwe wrote in message
news:688b7f7dce1e8@uwe...
hi!

i am getting #NA error for the following
array entered formula!

=INDEX(Sheet1!B1:B4,MATCH(A1,LEFT(Sheet1!A1:A4,3), 0))

what i am doing wrong?

help pl!

-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1