Display information by comparing a cell in Sheet 1 to a column of data in Sheet 4.

[Zimmerray1]

I would appreciate some help with information I need displayed by "Matching" a number in Sheet 1 to a number on Sheet 4. Here's how it works. The original "Part Number" will be in column B of Sheet 1. The information will be displayed in Column "I". The formula will look, for example, at Sheet 1 "B2" and compare it to all of the numbers in column "A" of Sheet 4. When the "Match" is found, the data in column "B" of Sheet 4 will be display in Sheet 1 cell "2I". There are over 2000 numbers in column "A" of sheet four that will be examined using this criteria. I have made a dummy spreadsheet and I will explain again what I need using data from it.

Cell 2B Sheet1 is highlighted yellow. Cell 2A Sheet4 is also. The formula should compare every number in Column "A" and when a match is found, display the "Description" in "B" Sheet4 in Cell "2I" on Sheet1. In this case, it would display "Ant". The numbers in Column "B" Sheet1 will be random. If the number in Cell "2B" Sheet1 would have been 111123, then "Green" would have been displayed in Cell "2I".

[hoyasaxa215]

Enter formula below in I2 and copy down as necessary.

Please Login or Register  to view this content.

[Zimmerray1]

Returns #N/A

[hoyasaxa215]

Please see attached. I'm not getting any errors.

[Zimmerray1]

Ah, I see what it is. =VLOOKUP(B2,Sheet4!$A$2:$B$20,2,FALSE) Should be =VLOOKUP(B2,Sheet4!$A$2:$B$2154,2,FALSE) There are actually 2154 rows to look through.

Works perfectly now! You are appreciated.

[hoyasaxa215]

Ah yes. That would be a problem. Glad you caught it.