Lookup or Index/Match

S

Scorpvin

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?
 
D

Dave Peterson

=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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup or Index/Match 2
Folder/Tabs Newbie Question 2
Linking Cells from different worksheets 6
Linking Cells from different sheets 1
IF, VLOOKUP or MATCH? 2
Lookup or If, then Question 1
Password protect individual tabs in an excel spreadsheet 1
Formula's in linking spreadsheets 1

Top