vertical / horizontal lookup

[proctk]

Hi I want to look up accross cells then when a match is found look down that column.

I tried this =SUMPRODUCT(--('00042'!A7:F7="June"),SUMPRODUCT('00042'!H1:H1000=Formulas!A5),('00042'!E1:E1000))

no luck as sumproducts want the look up range to be the same size. Column E needs to be a variable as not all sheets have the exact same format and I want to pull the value from the column with the header "June". The header will always be on row 7.


Any help is great!

 

[T. Valko]

Here is a macro I just created using the macro recored... Looks ugly to me and I'm not an expert on this by any means

is there anyway to clean this up?

I'm not much of a programmer so someone else will have to pitch in on this one.

I'm sure this can be reduced to a few lines of code if the right person sees this thread and responds.