Hi I have used the following to copy a sheet name into cell
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,1000)
Now I want to use the cell data (sheet name) to perform a Vlookup and return information. I keep getting an error because the cell data (sheet name) is not being recognized. How can I make the sheet name recognizable for the VLookup
Thanks
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,1000)
Now I want to use the cell data (sheet name) to perform a Vlookup and return information. I keep getting an error because the cell data (sheet name) is not being recognized. How can I make the sheet name recognizable for the VLookup
Thanks