help with search/lookup

[Guest]

I have 2 sheets.

Sheet 1 has just a few vendor numbers listed in column A.

Sheet 2 has ALL vendor numbers (about 30,000) in Column A and the vendor
name in Column B.

I want to do a formula in Sheet 1(cell B1) that would search sheet 2, and
match the vendor number with its corresponding name and show that name in B1.

anyone know how to do that???

Please help! Thanks!

 

[Guest]

Basic vlookup function:

In Sheet1, Cell B1 put:

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

Then you can copy this formula straight down the column in Sheet1 in the B
column and it will look up all the vendor names for which you have the number
listed in Column A on Sheet 1. The first variable will automatically change
as you copy it down the column from A1, to A2, A3, etc.

 

[Guest]

Thanks, That worked...

Basic vlookup function:

In Sheet1, Cell B1 put:

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

Then you can copy this formula straight down the column in Sheet1 in the B
column and it will look up all the vendor names for which you have the number
listed in Column A on Sheet 1. The first variable will automatically change
as you copy it down the column from A1, to A2, A3, etc.