Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup cell contents in on sheet based on a formula in second sheet
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 -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
=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. -- Vasant "Michael Wright via OfficeKB.com" wrote in message ... 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 -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |