Dave,

I tried the link you sent, and I tried one of the sample formulas from that
web site, but I am still getting "#NA". The follwing is the formula I am
using

=INDEX(ALSTAR!$C$2:$C$49878,MATCH(TEXT(B19,"00000" ),ALSTAR!$A$2:$A$49878,0),MATCH(TEXT(E19,"00000"), ALSTAR!$D$2:$D$39999,0))

I am using the "TEXT" function because there is a mixture of text and
numbers in the data. I want the "PLISN" from the "ALSTAR" worksheet to
appear in the "SLIC" worksheet in the column "ALSTAR PLISN". A sample of the
data follows:

SLIC Worksheet

(B) (E) (F) (G)
(J) (K)
SLIC ALSTAR
Ref. No.* Provn. LCN* Provn. ALC* LCN Type* PLISN PLISN
4116-337 AFALCASY 1 P EHMA
24A55B AFALCANY 0 P DVTA
M6325 AFZ 0 P ZKFA
AN833-6D AFAEACRY 0 P BQFA
24-00157-823 AFALCAFY 3 P FJMA
24-00157-823 AFALEAAY 3 P HGDA
24-00157-823 AFANAAREY 0 P JPPA
24-00157-823 AFASGY 0 P KZSA



ALSTAR Worksheet

(A) (B) (C) (D)
REFN PCCN PLISN LCN
13347750 ELBACE AAAA AF
13347750 ELBDUM AAAA AF
13347750 ELBDUM AAAA AF
13347750 ELBACE AAAA AF
13347750 ELBDUM AAAA AF
13347750 ELBDUM AAAA AF




--
God Bless!


"Dave Peterson" wrote:

So part numbers go down (say) column A and LCN's go across (say) row 1.

If yes, then take a look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html

She's got a few examples there.

Malone wrote:

I have 2 worksheets that I need to compare "Part No" and "LCN" to return the
"PLSIN" associated with the match between the worksheets of the two data
points. Can anyone provide guidance?

--
God Bless!

--

Dave Peterson