ive got a workbook, that has a worksheet called Query that If you type a number in a Given cell in this case H2. It returns the Sheet names (that are hidden ATM) on the same sheet in cells H15-H81. Sheet names are in mmm dd,yyyy format. What i would like to see happen is that if any of sheet names appears anywhere in H15-H81, I want the workbook to show those sheets and those sheets. If H15-H81 dosent have anything dont show sheets. FYI 2 Sheets Must be Exempt from the Rule. Sheets named Blank, & Query. Those must stay unhidden at all times. make sence??


And H15 thru H81 is a formula that actually returns the tab names

=IF(ISNA(MATCH(H$2&"_"&ROW(W1),Y$1:Y$550,0)),"",INDEX(X$1:X$550,MATCH(H$2&"_"&ROW(W1),Y$1:Y$550,0)))


For further Clarification...

Scenerio A: If I was to type 12345 In H2...H15 thru lets say H17 returns lets say
H15 comes back with Jan 15, 2008
H16 comes back with Mar 17, 2008
H17 comes back with Jun 21, 2008

Cells H18-H81 has the formulas but it remains blank as it should

From the formula above. If Cells H15-H81 has something like above...show sheets Jan 15, 2008, Mar 17, 2008, & Jun 21, 2008.

Scenerio B: I type 56789 In H2...H15-lets say H22 returns
H15 comes back with Jan 15, 2008
H16 comes back with Feb 17, 2008
H17 comes back with Mar 21, 2008
H18 comes back with May 1, 2008

H19 comes back with May 15, 2008
H20 comes back with Sep 17, 2008
H21 comes back with Sep 21, 2008
H22 comes back with Oct 1, 2008 etc.etc..

It should show those tabs...I hope this makes sence..Thank you so so very much...im pulling my hair trying to get this to work