How many tabs? What are their *REAL* names? What is the range of interest
(eg - A1:B10)?

Biff

"jillteresa" wrote
in message ...

Hi there -
How can I get a vertical lookup or sumIF formula to check multiple tabs
for a given value?

Or - is there a way to specify the tab? For instance, put "Tab A" or
"Tab B" in Cell A1, and have the lookup formula reference the value of
Cell A1.

Thanks for your help,
Jill


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