Finding part number on seperate worksheet

[dac1517]

I have what should be simple, but I am having an issue. I have 2 worksheets one is a master file and the other is a file of specific parts. What I need to do is identify which parts on the master file worksheet are present on the specific parts worksheet. I have tried the below two formulas to no avail

vlookup(N5,UK!A:D,4,false)
Match(N5,UK!A:A,0)

UK worksheet is sorted by part number in column A and there are no duplicates present.

Any help would be appreciated.

 

[tweedle]

What is the data type (text/numeric) for UK Col A versus N5?

 

[dac1517]

They are both in the format of text such as LW12345. The part numbers are exact matches.

 

[Yahya]

if you get N/A# make sure the Number or Text in Cell N5 and colum A are same
make sure there is no Extra Space
Try this
vlookup(trim(N5),UK!A:D,4,false)

 

[dac1517]

That seem to have worked. Thanks