I'm trying to use a de-reference to look up a...

[Joshua_Giles]

I’m trying to use a de-reference to look up all inputs from a specific user on a certain date.

I’ve had the user input their name, and the date they are looking up and I would like a drop down list of all orders filled by them filtered by the previous columns of name and date. Any help?

[Steven_Coile]

What do you have currently?

[Aleksi_Alkio]

Try with this…

SELECT(TableName[Order],AND([NAME]=[_THISROW].[NAME],[DATE]=[_THISROW].[DATE])) in Valid_If.

[Joshua_Giles]

@Aleksi_Alkio You’re seriously the best!

@Steven_Coile the above solution worked. I do know that lookup functions like this have performance drawbacks. So if you have any solutions that strictly uses appsheet’s de-reference abilities, that would be cool to. For now this method works!