Match using fixed columns but dynamic row

[CROY1985]

Hi all
I'd like some help making the following more dynamic:

=IFERROR(MATCH(Y80,BudgetInputs!GO$26:GZ$26,0),MATCH(Y80,BudgetInputs!GO$26:GZ$26,1)+1)

effectively i want to make row dynamic, the Row i want to match within can be determined with the following formula:

=MATCH($M80&" - "&AB$3,BudgetInputs!$A:$A,0)

I've almost figured a way to do it using indirect (combining the above) but wondered if anyone knew a better, less likely to break, way?

Thanks

Chris

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Thanks for updating your profile.
How about

=LET(x,INDEX(BudgetInputs!GO:GZ,MATCH($M80&" - "&AB$3,BudgetInputs!$A:$A,0),0),IFNA(MATCH(Y80,x,0),MATCH(Y80,x,1)+1))

 

[CROY1985]

Thanks for updating your profile.
How about

=LET(x,INDEX(BudgetInputs!GO:GZ,MATCH($M80&" - "&AB$3,BudgetInputs!$A:$A,0),0),IFNA(MATCH(Y80,x,0),MATCH(Y80,x,1)+1))

This works perfectly. Loving the "LET" function, had no idea it existed!

 

[Fluff]

You're welcome & thanks for the feedback.