VLOOKUP

[mlandry62]

Struggling to get VLOOKUP to work with multiple workbooks.

Second screenshot is the master spreadsheet, which by the way there are 10 of these!
The first sheet looks at the account numbers in Group 4110 to compare against Col B numbers and return the value from Col K to the Visual value.
Hopefully I've explained myself properly.

Issue I have is Multiple Trial Balances (2nd Screenshot) and account numbers in first screenshot have extensions that relate to the multiple trial balances.

Any assistance or advice would be greatly appreciated.

 

[mlandry62]

To combine use a formula like this in a cell

=B1 & “-“ & A 1

Produces
nnnn-AAA result

Awesome, it worked.
I had started with Concatenate then changing the characters to text and placing a dash in front.
Your solution so MUCH easier.
Thank you.

 

[mlandry62]

The project was successfully completed.
Thanks for helping out the novice!

 

[Anonymous1378]

I have never heard of the TBLINK function, are you sure it's an Excel function?

It's part of an xlam which I believed was being used for trial balance consolidation, though I may have been wrong here.