+ Reply to Thread
Results 1 to 2 of 2

Lookup or Index/Match

  1. #1
    Registered User
    Join Date
    09-29-2005
    Posts
    74

    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?

  2. #2
    Dave Peterson
    Guest

    Re: 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1