Looking for some guidance on automating XLOOKUP across multiple tabs and columns please

excelsiorsq

New Member
Joined
Jun 11, 2023
Messages
1
Office Version
  1. 365
Platform
  1. 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:

  • 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,"")
These formulas are working well for now. However, I'd like to replicate them across all other columns that correspond to specific dates. The aim is to have the dashboard update automatically when new data is imported into the software-based tabs for 2022 and 2023.

Could anyone guide me on how to achieve this? Any help would be greatly appreciated!

Thank you so much in advance
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,231
Messages
6,170,885
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top