lookup problem

[Todd Fischer]

I have a sheet with J11 called Buyers # and K11 called Buyers name. On the
next sheet called Buyers there is a list with B1 being the buyers number,
and C2 is the buyers names. How can I enter a number on the first sheet and
get the corresponding name to come up?

Todd

 

[Don Guillett]

Have a look in HELP index for VLOOKUP

 

[Bill]

Hi Todd,

In cell K11, put the formula:

=VLookup(J11,sheet2!B1:C100,2,false)

This assumes that your list of Buyers and numbers are on sheet2, cells
B1:C100. Adjust the text in the formula as required

Regards,

Bill

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***