LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LookUp with Mulitple Criteria TimR Excel Discussion (Misc queries) 4 July 13th 06 12:22 AM
Lookup mulitple values and return one Jim Excel Worksheet Functions 1 March 23rd 06 03:23 PM
search all tabs for tab name specified & lookup reference? BMW Excel Worksheet Functions 5 November 4th 05 04:16 PM
Lookup Vector > Lookup Value Alec Kolundzic Excel Worksheet Functions 6 June 10th 05 02:14 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"