vlookup and named ranges

[Hcleslie]

I am having problems using vlookup and cell with named range to return value.

If I manually put in the formula =VLOOKUP($B$4,'IFS Rates Sheets 6-01-05 2.xls'!National_Rate_Chart,VALUE($C$
3+1)) the formula works.

I would rather use =VLOOKUP($B$4,$C$2,VALUE($C$
3+1)) with the cell C2 having the name of the name of the range.

Thanks for any suggestions.

Charlie

 

[GlennUK]

put INDIRECT around the $C$2

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.