vlookup with indirect function

[BNT1 via OfficeKB.com]

Hi

Have looked at similar threads but have not found the solution

=vlookup(a1,mpg,4,0) works ok

what i require is the 4 to be replaced by the number in R2

=vlookup(a1,mpg,indirect(R2),0)

Cell R2 = 4 mpg is a defined range in another sheet in the same workbook

Keep getting #REF!

Help appriciated

Regards

Brian

 

[PCLIVE]

Do you really need to use "INDIRECT"?

=vlookup(a1,mpg,R2,0)

HTH,
Paul

 

[BNT1 via OfficeKB.com]

Your right ! Dont know what I was thinking

Thanks for the speedy responce

Brian

Do you really need to use "INDIRECT"?

=vlookup(a1,mpg,R2,0)

HTH,
Paul

Hi

[quoted text clipped - 15 lines]

Brian