You might like vba FIND better. Look in the HELP index.

--
Don Guillett
SalesAid Software

"ExcelMonkey" wrote in message
...
I have a 2D array with text strings (sheet names) in
column 1 and boolean values (1 or 0) in column 2. I want
to be able to do a lookup of the boolean values for each
sheet within the sheet name array while in a For Each
Loop.The idea being that I will do search based on name
propterty of the sheet that I am looping through.

For each Sh in Workbook
Lookup boolean in column 2 of SheetName Array based on
sh.Name
Next

Not sure how to use lookups in VBA