lookup problem

  • Thread starter Thread starter Todd Fischer
  • Start date Start date
T

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
 
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 ***
 
Back
Top