Forum Discussion
Hema86
Sep 05, 2022Copper Contributor
Need help in multiple lookup values and multiple lookup array with different headers
Hi team, I have to compare two workbook and get the not matched records. Workbook one is Source file and another is local file which has same values with similar header name but not same name. I t...
sivakumarrj
Sep 06, 2022Brass Contributor
It seems that vlookup array may be out of range for calculation.
Please check the below document for clarification
https://support.microsoft.com/en-us/office/-spill-error-extends-beyond-the-worksheet-s-edge-b3406d00-be0b-4a68-9976-40143ec7b55f
Please check the below document for clarification
https://support.microsoft.com/en-us/office/-spill-error-extends-beyond-the-worksheet-s-edge-b3406d00-be0b-4a68-9976-40143ec7b55f