Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Merging information

Merging information

ResolvedVersion Standard

Thu 21 Feb 2008, 17:33 Delegate Christof said...

Christof has attended:
Excel Advanced course

Merging information

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?

Thu 28 Feb 2008, 11:31 Delegate Christof said...

Also

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:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Merging information

Merging information

Also

Excel articles

Excel tip:

Hiding and unhiding columns using the keyboard