Thread: Variable lookup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
 
Posts: 108
Default Variable lookup

#REF! error

"Max" wrote:

=VLOOKUP(C2,tblCAB2,9,FALSE)
where tblCAB2 will be determined by the value entered in B2,


Try INDIRECT, ie: =VLOOKUP(C2,INDIRECT(B2),9,FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---