Thread: Summary
View Single Post
  #2   Report Post  
Old June 5th 09, 05:02 AM posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Summary

Hi,

If you have a common field in both files then use VLOOKUP, look this up in
the help system.

We can't see your files so its just a guess what the look like. The general
form of the formula would be:

=VLOOKUP(A1,'[Chapter 07 - Printing Charts.xls]National
Debt'!$A$1:$D$100,2,FALSE)

Where column A of both files contains the common element, the data you want
to lookup is in column 2 of the range A1100 .

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tofimoon3" wrote:


Dear sir,with best regards,in attached file i have two schedules ,one
for details of the invoices contents and the second for ( summary) of
these contents . i ask you kindly the way ( by formulas or codes) to
transfer the data from schedule 1 to be as mentioned in 2.
Thanks in advance.




--
tofimoon3