indirect / vlookup help

G

Greyling

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.
 
D

Dave Peterson

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top