Hi all,
I would like the formula to find the pricing across multiple tabs and the problem is the pricing column.
The pricing column is situated on a different column letter on each tab.
Would it be possible to replace the 1 from the formula to a match function? like the formula below...