Remember Me?

#1
April 30th 05, 04:05 PM
 Michael Wright via OfficeKB.com Posts: n/a
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
April 30th 05, 04:11 PM
 Vasant Nanavati Posts: n/a

=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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post dave m Excel Worksheet Functions 13 April 29th 05 01:12 PM michaelspearin Excel Discussion (Misc queries) 3 December 3rd 04 09:27 PM bpat1434 Excel Worksheet Functions 1 November 7th 04 12:43 PM bpat1434 Excel Worksheet Functions 1 November 7th 04 03:12 AM bpat1434 Excel Worksheet Functions 1 November 6th 04 05:17 PM

All times are GMT +1. The time now is 07:43 AM.