matching two worksheets and return to different value

[Dan]

Hello,

Can anyone help me please. I have two worksheet and each contain vendor
code. I just want to match the vendor code and then return to their phone
number.

sheet 1

abc
def
ghi
jkl
mno
pqr
stu
vwx
yza

Sheet 2
vwx 262-5555
jkl 262-5556
pqr 262-5557
mno 262-5558
stu 262-5559
dej 262-5560
ghi 262-5551


Thanks

 

[Teethless mama]

=VLOOKUP(A2,Sheet2!$A$2:$B$8,2,0)

adjust your range to suite

 

[smw226 via OfficeKB.com]

Hi Dan,

You need a Vlookup for this.
It gets a little more complicated amending a formula posted here when they
are on different sheets as it is easy to move a ' meaning your code won't
work.

If you type =vlookup( into your forula bar then click oin the fx to the
left you will get the prompt and should be able to work it out.

Lookup value is the cell on sheet 1 which containts the value you want to
look for on sheet 2

Table array is the whole table on sheet 2 which should have the list of
vendor codes in the far left column and include the value you want to return
(A1:C2)

Col_index_number will be the number of columns accross from the far left
which contains your phone numbers (if the venor code is in column A and the
phone number is in column C, you will want 3)

Range lookup should normally be set to FALSE

HTH

Simon