Forum Discussion
Multiple sequential vlookups
Hi!
I use Excel 2016. I have one very large excel file that I must validate several columns of data by comparing it to 3 other workbooks in a certain order. I VLOOKUP against the first workbook and then perform the second round of VLOOKUPS against the second work book for any #N/A caused by the first VLOOKUP and so on. Then I compare the data using the EXACT function. My question is - is there any way I can automate this process
2 Replies
Bee25523 Possibly with Power Query. But difficult to explain exactly how without seeing your files. Can you create some realistic example files (not too big) and the expected result? Save them on OneDrive or similar and post the links that give access to them here.
- I’ll try to get some examples together to post. Thanks!
