Select to view content in your preferred language

pulldata() with multiple filter criteria

313
1
03-13-2023 12:41 PM
AlexSteiner
New Contributor II

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!

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

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