View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] GastonFranzini@gmail.com is offline
external usenet poster
 
Posts: 15
Default referencing to a sheet that it`s name is stored on a cell

Is there a way to change the sheet name in a formula with a name that
is stored in a cell?
I have a vlookup that looks in sheet1 range. I have in the Cell a10 the
name of the sheet I want to lookup the value.

Thanks
Gastón