Return Data based on two conditions being met

Lyn Pringle

Hi,

Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently.

If Property Name is "Mykonos" and if Quarter 2, then return the % Score

I keep getting "Incorrect Argument Set Errors" :(

In the Matrix, I will have all the property names populated and will need to return the score achieved based on the quarter submitted.

Thanks in advance for your assistance

Andrée Starå

@Lyn Pringle

Happy to help!

Glad you got it working!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Lyn Pringle

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lyn Pringle

Thanks so much for the quick reply and for the assistance

Here is an example of what the capture sheet would look like - this is populated via form and where I would need to pull the data from.

Quarter Column is a drop down Q1, Q2, Q3, Q4

Score and Percentage are calculated.

All properties that submit responses will be listed in a separate sheet where I would need to pull the relevant % earned into the respective Q column. This information will then be used to report back into a dashboard graphs.

Thanks again for your assistance

Regards

Lyn

Andrée Starå

@Lyn Pringle

Apologies, I missed your reply.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Lyn Pringle

@Andrée Starå  thanks so much for getting back to me. I eventually managed to get this working by making use of multiple VLookUps.😊

Andrée Starå

@Lyn Pringle

Happy to help!

Glad you got it working!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!