How do I ref. a cell range and populate adjacent cells?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Can anyone help me with this?
In sheet 1 I want to have a look up reference in a cell
say "B5" (Cat No.)that will give me the choice of all the
data in another sheet called "Stock" in column "B" (Cat
No.). Also I need to bring in the data located in the
right 2 columns "C & D" (Description & Price)of the
selected Cat No. (i.e. same row of the selected Cat No.)
and populate cells "C5 & D5" of sheet 1.

Suggestions Please
 
Hi Mike, I wish i could help ya, but i can't. I came in here to ask the same question i think.
all i'm looking to do is enter a part number in say "b2" and then the description would appear in c2 and the list price in d2. Well i hope we both get our answers. Thanks
 
Back
Top