Lookup up items on another sheet.

**Keytonic** · 06-23-2009, 01:52 PM

First it's been forever (5 years) since I've done any scripting and it's not like riding a bike lol.
I have a long list written twice in 2 worksheets worksheet A has a list with some of the numbers repeated. worksheet B has the same list (none repeated) and another list with new numbers beside it. What I need is to take the new numbers from worksheet B and put them next to their correlating number in worksheet A. With many of the numbers being repeated I need something to identify and repeat the new #. I'd copy and paste and drag etc. but there's about 21,000 numbers to go through. An idea where to get started would be greatly appreciated. Thank you

**NBVC** · 06-23-2009, 01:55 PM

Try

=Vlookup(A2,Sheet2!B:C,2,FALSE) and copy down.

where A2 contains first number to check in Sheet2 column B and return item in Column C.

**Keytonic** · 06-23-2009, 02:52 PM

Ok I reformatted to my workbooks specs and keep getting the #REF! error. Everything looks ok unless I'm missing something sipmle here's what the formula looks like now

=VLOOKUP(B6,'Material Cross Reference List'!A:A,'Material Cross Reference List'!B:B,FALSE)

does something pop out that's screwy to you? Thanks