Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merging information
Resolved · Low Priority · Version Standard
Christof has attended:
Excel Advanced course
I have two Excel files. Both are a list of booking information like reference name dates and room rate and so on.
One workbook has additional information how much the hotel charged for the booking. Both workbooks have the reference numbers of the booking. How can I get the charge information from one book merged into the other?
I found something that does the trick... however at a price... do you know a formula that could do the same?
http://www.ablebits.com/excel-lookup-tables/index.php
|
Excel tip:Moving between Worksheets without using the mouseUse the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys. |
We'll call during UK business hours
Server loaded in 0.07 secs.