indirect / vlookup help
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. |
indirect / vlookup help
=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 |
All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com