I would like to refer to a worksheet name from a cell value
is there a formula equivalent to the VBA Worksheets(Range("A1").Value)
I want to use this in a vlookup function
=VLOOKUP(I27,Input!C10:D18,2,FALSE)
Where Input! would be replaced by Worksheets(Range("A1").Value)
and Range("A1")=Input
Thanks
--
caroline