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