=VLOOKUP(K8,INDIRECT("'"&$C$4&"'!C$1:X$200"),22,FA LSE)

Those extra apostrophes won't hurt if they're not needed. So it's a good idea
to always include them.

Greyling wrote:

I've got my formula working:
=VLOOKUP(K8,INDIRECT($C$4&"!C$1:X$200"),22,FALSE)
except where I have a space in the sheet name... Is there a way of
modifying the formula to account for the space? I'm not keen on changing the
names as they relate to specific areas that are recognizable to a long list
of users, & to alter them changes meaning.

--

Dave Peterson