Dynamic Named Range, COUNTIFs & VLookups

Hi,

Am after some help with the formula below - I want to use it to create a dynamic named range in Column R and use VLookup to match the month value (in this case March i.e. 3) in the named range 'Range_Month' which is a 2 column dynamic named range in Cols A &B (the month numerical value is in Col 1/A) - the end result being that I can create multiple dynamic ranges in the Col R for the month to which it corresponds.

I'm not sure what's missing/incorrect for it not to be working...help much apreciated!!

Name: Range_Profit_03

Formula: =OFFSET($R$2,1,0,COUNTIF(VLOOKUP(3,Range_Month,1,TRUE),$R:$R))

Thanks!

Could you post an example workbook? It would make what you are trying to achieve clearer.

On a side note, the COUNTIF syntax is incorrect. It should be:

=COUNTIF(range, criteria)

e.g. =COUNTIF(Range_Month,3)

I don't get how you are using the Vlookup to determine your range size.

If I lookup 3 in Range_Month, I get 3. Does that mean you want your range to be a size of 3 cells? Please clarify.

Still not 100% clear..

This maybe?

=OFFSET('Trading Log'!$R$2,1,0,MATCH(3,INDEX(Range_Month,0,1),1))

it will only highlight the 55 in this sample case.

It will highlight from row 3 to wherever the month number matches in corresponding column B.