Vlookup with other Wbook

[pedropacheco]

Hey guys!

Please, could you guys please answer my question.

How can i do vlookup value with an another workbook... but, the problem is, this another workbook always will have another name. So the code can't use a personal name for it.

Then, i will have the workbook that where's my code is wrote and this second where i will open previously but this one always will have another name... is it possible to do vlookup?

i know how to do vlookupvalue basically... but this way i'm talking i do not have any ideas

 

[Radoslaw Poprawski]

Kinda you can

First you have to make a Table with some header and just 1 row with file path and filename.
you would have to find VBA code for retreving all files within that folder and filter it to the desired one.

Or you also could use PQ.

The rest is simple. do a PQ. and go for one of the join type. from your description Left Outer or full join would be what you want.
If you provide 2 sample files ill help with the PQ solution.