Vlookup of 1 cell containing multiple search arguments

Hi,

Spreadsheet 1
Cell A1: Document reference
Cell A2 = contains (list of numbered action items associated to the specified document in A1)[list is separated by commas within this cell)

Spreadsheet 2
A1: A4 contains the numbered action item
B1: B4 gives the status per action item (IE. open, closed)

I want to find a way take all the listed action items within Cell A2 and cross reference them with spreadsheet 2 to return all the associated status's.

Ideally then highlight the row, if any action item is found to still be open in that second spreadsheet. Or alternatively highlight the row if all action items are found to be closed.

I had gotten as far as a Vlookup that returns the status, but this only works if only one action item is listed in cell A2 of sheet 1.

I would greatly appreciate it if someone with advanced excel skills could help me out!

Thanks!