excelsiorsq
New Member
- Joined
- Jun 11, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I was basically working with XLOOKUP functions and I need to be able to pull data from two separate tabs. My goal is to automate this process as much as possible to avoid the need for all those manual adjustments with each XLOOKUP and reference cell change.
I have got:
Could anyone guide me on how to achieve this? Any help would be greatly appreciated!
Thank you so much in advance
I have got:
- In Row 1, I'm using the formula =XLOOKUP(A6,'SALES VALUE 2022'!A6:A190,'SALES VALUE 2022'!D6:D190,"-",0)
- In Row 2, I'm using =XLOOKUP(A6,'SALES VALUE 2023'!A6:A155,'SALES VALUE 2023'!H6:H155,"-",0)
- In Row 3, I'm using =IFERROR((B6-C6)/C6,"")
Could anyone guide me on how to achieve this? Any help would be greatly appreciated!
Thank you so much in advance