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

One way is to use INDIRECT,

something like this in say, B1:
=HLOOKUP('General Fund'!G$1,INDIRECT("'" & A1 & "'!B4:CM4"),1,FALSE)

where A1 contains the text: Sheet1
(had assumed the contents of A1 indicated in your post was a typo)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Using the name of a worksheet written in" <Using the name of a worksheet
written wrote in message
...
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

Use INDIRECT()

in place of Sheet1!$B$4:$CM$4
use INDIRECT(A1 & "$B$4:$CM$4")
--
Gary's Student


"Using the name of a worksheet written in" wrote:

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