Hey!

I am using a function to determine the name of the worksheet and place it
into a cell:

=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,6)

I then want to use the output of this cell [the first one is 1001] to feed
into a vlookup:

=VLOOKUP($K$2,List!$I$2:$K$579,2,FALSE)

This works when I type 1001 into cell K2 but does not work when I use the
first function to generate 1001 in cell K2. Both are formatted as
number|general.

I've tried several things - and the only thing that works in the vlookup
function is if I physically type the sheet name [a number] into cell K2.

Help? I must have missed something obvious.

Thank you!

Patrick