Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Summary
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 A1:D100 . -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary help! | Excel Worksheet Functions | |||
Summary using VBA | Excel Discussion (Misc queries) | |||
Summary SUM | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) |