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