Hi,
I'm not sure how I get value from header match e.g. I need a criteria to match header with a cell, if match want to get a value of a sum cell, how would I write a formula?
as per pic:
Column A is the criteria to match Row 1 (E1:J1)
Give me answer Row 9 (E9:J9) if match, answer to B2:B5
I'm not sure how I get value from header match e.g. I need a criteria to match header with a cell, if match want to get a value of a sum cell, how would I write a formula?
as per pic:
Column A is the criteria to match Row 1 (E1:J1)
Give me answer Row 9 (E9:J9) if match, answer to B2:B5