Thread: using the name of a worksheet written in a cell, inside a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Using the name of a worksheet written in
 
Posts: n/a
Default using the name of a worksheet written in a cell, inside a formula
How can I use the name of a worksheet written in a cell, inside a formula
(VLOOKUP/HLOOKUP). Ex. Cell A1 = BalanceSheet1
=HLOOKUP('General Fund'!G$1,Sheet1!$B$4:$CM$4,1,FALSE)

How to replace Sheet1 with the contents of Cell A1

Reply With QuoteReply With Quote