Substitute for Arrays in Excel Online (specifically Index/Match function)?

[csliger931]

Hi,
I have created an Excel Online workbook that I am using with Power Automate in order to pull in Survey123 results (results go into a "RAW DATA" tab). In my "SUMMARY" tab, I am presenting an overview of the Sump data by date. In order to pull specific data from the "RAW DATA" tab and match it by date and Sump ID, I am using an Index and Match formula. BUT, I didn't realize that Excel Online doesn't support Arrays! YIKES! Does anyone know how to get around this for my situation? Perhaps there's a different formula that I can use that doesn't depend on arrays?
In the first table below, I have my "RAW DATA" tab. In the second table is the "SUMMARY" tab. I need the replacement for the formula presented in the second table (cell C2), and the replacement cannot use arrays. Any help would be greatly appreciated. Thanks!
Chris

"RAW DATA"

05/03/22	CS-1	45
05/04/22	CS-2A	60
05/08/22	CS-1	110

"SUMMARY"

DATE	CS-1
05/05/22		{=Index('RAW DATA'C1:C3,Match(1,(A1='RAW DATA'A1:A3)*(B1='RAW DATA'B1:B3),0))}
05/04/22
05/03/22

 

[Fluff]

With Excel online you don't need to array enter formulae, so try entering it as a normal formula.

Also shouldn't the A1 in your formula be A2?

 

[csliger931]

Hey Fluff,
I feel like such an idiot now! You are entirely right, I was trying to enter the formula as an array and it wasn't working, and then after I read a post saying that "array is not included in Excel online), I panicked. Whoops. And yes, it should have been A2. All is good now, thank you for the help.
Much appreciated,
Chris

 

[Fluff]

Glad it's sorted & thanks for the feedback.