A quick one that someone reached out for help with
=INDEX(B2:E5, MATCH(B7,A2:A5,false), MATCH(D7,B1:E1,false))
Parameter 1: the values you want to search through (B2:E5
)
Parameter 2: The value (B7
) to look for and in the row range (A2:A5
)
Parameter 3: The value (D7
) to look for and in the row range (B1:E1
)
