Index Match Query

ireland87

Board Regular
Joined
Jul 22, 2015
Messages
52
Hi

I'm trying to have an index match or equivalent whereby in cell B5 in looks for a daily task then if there is one displays "Daily Task"

In cell B6 it then needs to look for a Post Task or a Month task

likewise in B7

I have the index match for looking to see if theres a task for each system but cant seem to link it together for what i need. Can anyone help?

IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily Task"
IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task"
IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task"
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Try

=IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily Task",IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task")))

though I dont understand why B5 and B6 and B7 dont exist in your formula?
 
Upvote 0
Hi

if this is in B5
=IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily Task",IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task")))

In B6 in needs to check if B5 is populated with option 1 "Daily Task" and continue but not duplicate itself
For example if B5 = Daily Task then I need the formula to move onto the next option i.e. Montly Task

and the same for B7

If i define B5 as Daily Task
B6 as Post Task
B7 as Month Task

would that help?

any ideas?

 
Last edited:
Upvote 0
If i combine some IF statements in B6 unfortunately it displays FALSE

for example if B5 = =IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily Task",IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task")))

Then B6 =
=IF(B5="Daily Task",IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task")),IF(B5=Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly Task"),""))
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top