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 |
=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 |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com