Search for a list of character strings in Text File or Json

I have two data-sets that I'm attempting to relate. Data Set 1 contains a list of strings in column A and the list of corresponding numbers for those strings in column B. Data-Set 2 is a text file (from a json result).

I'm unsuccessfully attempting make a list of 1B results if 1A exists in Data-set 2.

I can use 'query all records' to search for a single, static name (from 1A) exists in Data-Set 2 and it returns the corresponding data from 1B.

Do I need to put this in a loop to search for all items in 1A, can I just provide a list, or do I need to do something else entirely?

When I attempt to search for more than 1 item on the list I receive this error: 'Exception: ParseError:'