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

​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  Read More

​