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:
=(VLOOKUP(C$3&"*",INDIRECT("'"&"*"&$B4&"*"&"'!$A:$Z"),MATCH("Price",0)
I cannot work out a way to return a value when a the price column are situated in different column letters and tabs across the workbook.
Is there a solution to this formula please?
Thank you in advance
CT
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:
=(VLOOKUP(C$3&"*",INDIRECT("'"&"*"&$B4&"*"&"'!$A:$Z"),MATCH("Price",0)
I cannot work out a way to return a value when a the price column are situated in different column letters and tabs across the workbook.
Is there a solution to this formula please?
Thank you in advance
CT