Hi

Please see attached file as it is simpler to show by example. I am looking for a complex formula which will find multiple lookup values based on the column and header value. I have tried a lot of formulas but can not achieve the result.

Thanks in Advance

Adeel
Example Data.xlsx