Question: Automatically Filling Cells by Identifying Row

  • Thread starter Jennifer Waterhouse
  • Start date
J

Jennifer Waterhouse

I've made a fax sheet in excel with a number of blocks to be filled.
Company name, ph#, fax number, part #, etc.

All this information is present on another sheet when I input my order. The
first column on that sheet is my Purchase Order Number (IE : TT4153). The rest of the row contains the product description, Company name, ph#, fax number, part #, etc...

Here is what I would like to be able to do. Input the Purchase Order Number
in a cell on the fax sheet, press enter, and all the blocks on the fax sheet
would fill from the row of that Purchase Order.

Another way to explain it. A formula in the cell for the Company Name on
the fax sheet that would read the Purchase Order Number cell, then find that
row on sheet 2 and take whatever was input in, let's say column 'H'.

Any help would be much appreciated

MIKE
 
P

Paul Lautman

It sounds like you're looking for the VLOOKUP function

I've made a fax sheet in excel with a number of blocks to be filled.
Company name, ph#, fax number, part #, etc.

All this information is present on another sheet when I input my order. The
first column on that sheet is my Purchase Order Number (IE : TT4153). The
rest of the row contains the product description, Company name, ph#, fax
number, part #, etc...

Here is what I would like to be able to do. Input the Purchase Order Number
in a cell on the fax sheet, press enter, and all the blocks on the fax sheet
would fill from the row of that Purchase Order.

Another way to explain it. A formula in the cell for the Company Name on
the fax sheet that would read the Purchase Order Number cell, then find that
row on sheet 2 and take whatever was input in, let's say column 'H'.

Any help would be much appreciated

MIKE
 
Top