MATCH function

[T1991]

I have two sheets:
Master sheet
Supporting sheet
I am trying to pull any names from column G in Master to column C in Supporting but only if the row meets the following requirements:
The values in columns H, I and J in Master match the cells A11, B10 and A4 in Supporting.
I only want it to pull the first instance of the name and then move onto the next one. I have copied this formula as an array into C11:C20 in Supporting:
=IFERROR(INDEX(Master!$G$3:$G$100, MATCH(0, COUNTIF($C$10:C10, Master!$G$3:$G$100) + IF((Master!$H$3:$H$100=$A11)*(Master!$I$3:$I$100=B$10)*(Master!$J$3:$J$100=$A$4), 1, 0), 0)), "")

Additionally, I want to take a similar approach for column F in Supporting, where the match requirement will change from:
Master!$I$3:$I$100=B$10 to Master!$I$3:$I$100=E$10

However it just keeps pulling the same names from column C.

Any advice would be more than welcome. I have been on this for days

 

[Fluff]

The problem is col J, J7 is 24 Jan & J8 is 1 Jan.

 

[T1991]

The problem is col J, J7 is 24 Jan & J8 is 1 Jan.

Oh dear, I can't believe I missed that. Thank you so much. I've literally been on this for days and it was something that simple. On the user form I've been typing 01/24 because I've set the date format to MM/YY. I didn't realise it was inputting it as 24/01/24. Is there any way around that? Or is it as simple as typing 01/01/24 in the user form?

 

[Fluff]

Either enter the whole date, or make it text.

 

[T1991]

If I have an additional query that's an extension of this, do I need to post it as a separate item?

I have additional columns in the Master sheet that I'd like to also pull.

So in Master, if the date in column Q matches A4 from Supporting, I'd like it to pull the name from G again as a separate item but with the word "replacement" at the end.

Then if the date in column X from Master matches A4 from Supporting, I'd like it to pull the name from column W from the same row as a separate item.

Is this feasible or is that too many arguments for a formula?

 

[Fluff]

That is a significantly different question, so needs a new thread. Thanks