Anyone know how to do a two dimension lookup? I know I could use an index match in excel or xlookup, but how do I do that in appsheet?
Did you try using LOOKUP(): https://help.appsheet.com/en/articles/2357309-lookup
As @Harsh_Ch suggested, (btw: Welcome to Communityโฆ),
You can do that with AppSheetโs LOOKUP, but, you need to create the table for the lookup to work. Something like Unpivot the pivot table and add that table to AppSheet, sample like below snapshot:
Thanks for the advice. Lookup doesnโt really work for me since the variables in the function donโt offer the ability to be dynamic. I did change my table to look more like Heruโs example, but I ultimately went with a Select function with an And function embedded.
It looked like this.
Select(School Days[School Day], and([School]=[_thisrow].[School],(today()+7)=[Date]))
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |