Hi team,
I feel like I'm not that far off from what i want to achieve, but what I'm essentially trying to do is
have multiple criteria reference a table where there are 2 criteria are dynamic ref cells.
With Sheet2, i managed to get it to work somewhat, but it the result doesn't show the first Service
for the customer in the table. As in it lists all the correct services except for the first. I'm not sure how
to get the second criteria "Category" to work either.
Sheet1's formula does what I want it to, but instead of displaying all the relevant records, it dupes the
same record.
https://www.dropbox.com/s/6sw2aaxdk0hu1v0/TestSheet.xlsx?dl=0
Can anybody please help?
I feel like I'm not that far off from what i want to achieve, but what I'm essentially trying to do is
have multiple criteria reference a table where there are 2 criteria are dynamic ref cells.
With Sheet2, i managed to get it to work somewhat, but it the result doesn't show the first Service
for the customer in the table. As in it lists all the correct services except for the first. I'm not sure how
to get the second criteria "Category" to work either.
Sheet1's formula does what I want it to, but instead of displaying all the relevant records, it dupes the
same record.
https://www.dropbox.com/s/6sw2aaxdk0hu1v0/TestSheet.xlsx?dl=0
Can anybody please help?