vlookup with indirect function
 

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

--
Message posted via http://www.officekb.com

vlookup with indirect function
 

Do you really need to use "INDIRECT"?

=vlookup(a1,mpg,R2,0)

HTH,
Paul


--

"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:8102b84972b21@uwe...
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

--
Message posted via http://www.officekb.com

vlookup with indirect function
 

Your right ! Dont know what I was thinking

Thanks for the speedy responce

Brian

PCLIVE wrote:
Do you really need to use "INDIRECT"?

=vlookup(a1,mpg,R2,0)

HTH,
Paul

Hi

[quoted text clipped - 15 lines]

Brian

--
Message posted via http://www.officekb.com