Array inside a formula using data from three separate tabs

pt5040

New member
Joined
Jun 26, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2013
I have three large datasets on three separate tabs. I need to combine one data point from each tab inside a formula so that the formula sees these as an array. So, is there a way to create an array from cells that are not next to each other on the sheet?

I need to do this over and over about a 1000 times, hence formula better than manual.

Thank you,
Phil
 
Back
Top