I'm trying to write a formula which looks up the name of a worksheet to check if its in the index list.

=SHEET returns the number of the worksheet, but is there a way I can get the assigned name into this formula please ?

=vlookup("this worksheet name",index!A:A,1,false)

A more elegant way to do it would be a formula that says If this worksheet name is in the index, then "ok", else "not indexed". I can only think of vlookup though.

Thanks

T'dub