Just use the names of the sheets you are targeting. The formula will
INDIRECT into those sheets.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"J@Y" wrote in message
...
I have this formula that uses MySheets as a list of sheets.


=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySh
eets&"'!A2:A200"),A2)0),0))&"'!A2:C200"),3,0)

How would I name my sheets?