Lookup cell contents in on sheet based on a formula in second sheet

[Michael Wright via OfficeKB.com]

I have two sheets in a workbook - one a list of customer quotations - the
second an invoice proforma.

I want to enter an invoice number in the proforma - then have it look up
values in various cells in the quotation sheet based on it = the invoice
number in the quotation form [this is contained in the first column of the
quotation sheet].

Hope this makes sense.

Any help greatly appreciated.

Regards,


Mike W

 

[Vasant Nanavati]

=VLOOKUP(A1,Sheet2!$A$1:$H$100,2,FALSE)

assuming:

A1 is the cell on the invoice proforma sheet into which you enter the
invoice no.,

Sheet2 is the quotation sheet,

A1:H100 on Sheet2 contains the quotation data, and

2 represents the column number on the quotation sheet from which you want to
"pull" the data associated with the matching invoice no.