Search for multiple criteria and return value

[tjdate]

I already use a index match formula on a different spread sheet which works exactly as it should so thought i understood the formula, however, when i have used it again on a different sheet to achieve the exact same goal, the correct data is not displayed and I can not for the life of me work out why!

I have attached an example spreadsheet and would appreciate anyone's help, i suspect I am missing something very small, however, who knows!

Cell F2 on Google sheet- It should show data for site 1 for 30/09/2022 which it does

Cell G2, H2 and I2 on Google sheet- These should show data for the corresponding site for 30/09/2022 , however, none of them do

[Phuocam]

Try this in F2:

=IFERROR(INDEX('Connect team'!$I$2:$FA429,MATCH($B2,'Connect team'!$E$2:$E$500,0),
MATCH(F1,'Connect team'!$I$1:$FA$1,0)),"Error")

[AliGW]

Is this a GoogleSheets or Excel query?

[tjdate]

It is an Excel query, the data is being imported from a google sheet.

[JohnTopley]

Try

=IFERROR(INDEX('Connect team'!$I$2:$FA429,MATCH($B2,'Connect team'!$E$2:$E$500,0),MATCH(F1,'Connect team'!$I$1:$GA$1,0)),"Error")

Your rows/columns in your formula are reversed.

[tjdate]

Thanks Phuocam and JohnTopley. Cant work out why this makes a difference, however, it does and it works so thank you.

It has however raised another problem, however, I will post that as a separate post if i cant solve it.

Thank you for your time.

[AliGW]

In an INDEX MATCH MATCH, the row will be the first match and the column the second - that's what Excel expects. It's a simple rule, and once you get it, you won't make the same mistake again. Think in terms of xy co-ordinates - x comes before y.