View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jillteresa jillteresa is offline
external usenet poster
 
Posts: 1
Default Lookup mulitple tabs


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