Lookup or Index/Match
 

I have 6 tabs in my spreadsheet. 5 tabs represent each business day of
the week. The 6th tab is an all inclusive tab of tabs 1-5. On the 6th
tab I need a column for each record stating which tab the record could
be found (tabs 1-5). How would I do this?


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=542486

Lookup or Index/Match
 

=if(isnumber(match(a2,sheet1!a:a,0)),"Sheet1","")
&if(isnumber(match(a2,sheet2!a:a,0)),"Sheet2"," ")
&if(isnumber(match(a2,sheet3!a:a,0)),"Sheet3"," ")
&if(isnumber(match(a2,sheet4!a:a,0)),"Sheet4"," ")
&if(isnumber(match(a2,sheet5!a:a,0)),"Sheet5"," ")

Change the sheet names to match your days and the column to match where the key
is (as well as A2 to match your lookup value).


Scorpvin wrote:

I have 6 tabs in my spreadsheet. 5 tabs represent each business day of
the week. The 6th tab is an all inclusive tab of tabs 1-5. On the 6th
tab I need a column for each record stating which tab the record could
be found (tabs 1-5). How would I do this?

--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=542486

--

Dave Peterson