Thanks!
Real names:
I need a series of information associated with code 1004. That code
could either be located on tabs Q1, Q2, Q3, Q4. I'd like to set up a
formula that could default check all tabs. The other option would be
entering the Quarter into another cell and setting up the formula to
read that cell. So, if I know it is a Q2 code, I can put "Q2"
somewhere else in the sheet and the formulas would only check the Q2
tab.

Make sense?
Jill


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=562167