VLOOKUP or INDEX MATCH formula between two workbooks?

[booleanboolean]

Hi All,

I'll try to explain this as simple as possible:

I have two excel files/workbooks, 1) Call Log A 2) Call Log B

Process: Whenever I receive a phone call, I log information into Call Log B first, which then gives me a Confirmation Number (Unique Identifier). I then have to manually re enter most of the information from Call Log B into my personal Call Log A.

What I want to happen: When I type in the Confirmation Number (from Call Log B) into column K2 in my Call Log A, certain information from Call Log B will populate into the respective columns in my Call Log A.

In my Call Log A, I have columns, B, G, and I that would need to populate info from from columns G, I, and H in Call Log B.

Column B matches Column G (in Call Log B)
Column G matches Column I (in Call Log B)
Column I matches Column H (in Call Log B)

Call Log A is entitled "My Personal Call Log.xlsm" and Call Log B is entitled "Other Personal Call Log.xlsm" -- Yes, there are spaces in the file name I can't change.

Please provide any help with this. I have tried VLOOKUP, INDEXMATCH, and nothing seems to work!

 

[Coding4Fun]

Question - Where is the Confirmation in your Call Log B?

If it is not in Columns A to F then that is the problem and the reason your Vlookup is not working most likely. Please confirm.

Vlookup looks from left to right so your lookup column needs to be on the left of the values you are trying to return.