pulldata() with multiple filter criteria

Question

Hello,

Is it possible to utilize the pulldata() function to return a value from an external table based on two filter criteria?

For excample, something like this:

pulldata('Table_Name','Return_Column','Lookup_Column_1','Lookup_Value_1', 'Lookup_Column_2','Lookup_Value_2')

I know this can be done with appearance searches, but I have not found a way to make it work with a pulldata(function) in the calculation column.

Thanks!

dougbrowning · Answer

Creating a key that combines both fields as I posted above is still the only way I have seen.

DormodyPeter · Answer

Hi, I am also having the same issue as Alex. I need to be able to use the pulldown function and filter 2 lookup columns. Any solutions on how to do this or could you elaborate on your idea above.

Thanks

dougbrowning · Answer

I think I did this by adding a column to contact all the fields together.  Then concat in the form and use that in pulldata.  So basically making a key field.  You can have a formula in excel to do it for you maybe.

Hope that helps