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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top