software

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: www.excelforum.com/member.php...oamp;userid=27678
View this thread: www.excelforum.com/showthread...hreadid=542486=if(isnumber(match(a2,sheet1!a:a,0)),quot;Sheet1quot;,quot;quot;)
amp;if(isnumber(match(a2,sheet2!a:a,0)),quot;Sheet2quot;,quot; quot;)
amp;if(isnumber(match(a2,sheet3!a:a,0)),quot;Sheet3quot;,quot; quot;)
amp;if(isnumber(match(a2,sheet4!a:a,0)),quot;Sheet4quot;,quot; quot;)
amp;if(isnumber(match(a2,sheet5!a:a,0)),quot;Sheet5quot;,quot; quot;)

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:
gt;
gt; I have 6 tabs in my spreadsheet. 5 tabs represent each business day of
gt; the week. The 6th tab is an all inclusive tab of tabs 1-5. On the 6th
gt; tab I need a column for each record stating which tab the record could
gt; be found (tabs 1-5). How would I do this?
gt;
gt; --
gt; Scorpvin
gt; ------------------------------------------------------------------------
gt; Scorpvin's Profile: www.excelforum.com/member.php...oamp;userid=27678
gt; View this thread: www.excelforum.com/showthread...hreadid=542486

--

Dave Peterson