vlookup with stacked column headers

[cimanaxe]

Hi everyone,

I am trying to figure out how to use vlookup (or an equivalent) when there are two rows of column headers, and the lower row is repeating metrics.

For example, along row 2 you might have months, with each month spanning two columns wide. Then underneath each month, you would have the same two metrics (let's say PO Qty and Sales) for each month. Assuming my lookup criteria was Product Number, how could I find the PO Qty of a Product Number for a specific month?

Also, I realize there are better ways to structure the data, but these are reports from work.

Thanks!!

 

[Aladin Akyurek]

Try to implement something like:

=VLOOKUP(ProdNum,Table,MATCH(Month,INDEX(Table,1,1),0)+IF(Required="PO Qty",0,1),0)

Table stands for the area where the data is, including the 2 rows with headers.