Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 30th 05, 04:05 PM
Michael Wright via OfficeKB.com
 
Posts: n/a
Default 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   Report Post  
Old April 30th 05, 04:11 PM
Vasant Nanavati
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format based on contents of cell. dave m Excel Worksheet Functions 13 April 29th 05 01:12 PM
How do I automatically rename a sheet with the contents of a cell. michaelspearin Excel Discussion (Misc queries) 3 December 3rd 04 09:27 PM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 7th 04 12:43 PM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 7th 04 03:12 AM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 6th 04 05:17 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017