Converting google sheets forumla into excel formula

[Falcons88]

Hi,

I have a google sheets formula that i'm trying to convert into excel, I made the formula ages ago and it works on google sheets I just don't know what the equivalent is in excel, I just need to understand what ARRAY_CONSTRAIN(ARRAYFORMULA(INDEX is the equivalent to.

ARRAY_CONSTRAIN(ARRAYFORMULA(INDEX(Calculations!$B$2:$K$20, MATCH(H4,Calculations!$A$2:$A$20,0), MATCH(Calculations!$B$25,Calculations!$B$1:$K$1, 0))), 1, 1)

thanks in advance

 

[Fluff]

Looks like it should just be

=INDEX(Calculations!$B$2:$K$20, MATCH(H4,Calculations!$A$2:$A$20,0), MATCH(Calculations!$B$25,Calculations!$B$1:$K$1, 0))

 

[Falcons88]

Looks like it should just be

=INDEX(Calculations!$B$2:$K$20, MATCH(H4,Calculations!$A$2:$A$20,0), MATCH(Calculations!$B$25,Calculations!$B$1:$K$1, 0))

Thanks for replying Fluff, that's what i thought it would be but its returning NA#.

it's for a beer calculator, from the below im needing the formula to cross reference H4 with column A of calculation sheet below at the same time Calculations!$B$25 with top row.
E.g. if H4 = 35 (in column A) and Calculations!$B$25 = 1.06 (from top row) it returns 0.175

 

[Fluff]

That's exactly what that formula should do.
Check that all the numbers in col A & row 1 ,along with H4 & B25 are real numbers & not text.
The #N/A means that one (or both) of H4 & B25 cannot be found.