Adding a further criteria to formula

[Marvo]

I have the following formula that does what's required of it.

=IF(' Master'!G$65=1,XLOOKUP(' Master'!G$64,' Master'!G$4:G$61,' Master'!$B$4:$B$61),"")

However I'd like to add a further criteria. So if all the above is true, I only want the result if in the matching part of the formula

Master'!$B$4:$B$61

there was a figure above 18 (18>) in the corresponding

Master'!$C$4:$C$61

I'm not sure whether I need an IF + AND statement at the start or more likely a further IF before the match segment of the XLOOPUP.

I hope I've explained that okay.

Many thanks.

 

[Fluff]

How about

=LET(x,XLOOKUP(' Master'!G$64,' Master'!G$4:G$61,' Master'!$B$4:$C$61),IF(' Master'!G$65=1,IF(INDEX(x,,2)>18,INDEX(x,,1),""),""))

 

[Marvo]

Yes thank you, that works lovely. Unfortunately I've created myself another problem now I'll need to get my head round. Bugger!

 

[Fluff]

You're welcome & thanks for the feedback.