Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
77
Views
Hi,
I have files that looks to others files for V/XLOOKUP or Data-validation.
When I open such file I get a warining message:
I remember seeing a vidoe of Mynda saying that this can be avoided using PQ, which made me take the PQ course, but I can't think of which PQ method I should take for that.
Regards,
Ayal Telem.
Posted : 29/09/2023 9:31 am
Hi Ayal,
The lookup formulas are bringing data in from an external file. With Power Query you can use the Get Data > From File connector (lesson 2.02) to bring this data into your current file. Then you can use the Merge tools (lesson 3.05) to do the equivalent of a X/VLOOKUP.
Mynda
Posted : 29/09/2023 6:47 pm
Hi Mynda,
That's what I was looking for.
I can say with pretty high confidence: you're great : )
Regards,
Ayal Telem
Posted : 01/10/2023 1:04 am
glad I could help!
Posted : 01/10/2023 2:45 am
