Searching for a value with multiple criterias

[Charles33]

Hello again !

I am working on a small project where we have a table containing:

Names - repeatable in 1st column
Year - in two different columns
Pay
Days at work

I would like to search for a specific name in this table and show result for "Pay" and "Days At Work" for specific year (search for the YEAR in both columns (one of them is ALWAYS filled)..

This might be really simple but I am always struggling with multiple criterias and how to merge them in one formula..

Can you help me with this ?

[Glenn Kennedy]

use this copied across and down:

=INDEX('What I have'!D$2:D$13,MATCH(1,INDEX(((ISNUMBER(SEARCH(2017,'What I have'!$B$2:$B$13))+ISNUMBER(SEARCH("17/18",'What I have'!$B$2:$B$13)))*('What I have'!$A$2:$A$13=$A2)),0),0))

You may need ; instead of ,