I am trying to get information to pull from one tab to another and having issues. I believe it is because there can be multiple responses. I am trying to pull information based on table number. I have already used the following formula to pull information from this tab to a different one, but it doesn’t work for this situation because multiple lines have the same table number.

=IF(ISERROR(XLOOKUP(1,’Master Seating’!H$2:H$159,’Master Seating’!K$2:K$159,)),””,(XLOOKUP(1,’Master Seating’!H$2:H$159,’Master Seating’!K$2:K$159,))) 

Is there a way to edit this formula to work or another formula that I should be using. 

I have attached screen grabs of the workbooks. From the first workbook I want to pull the names and allergies into the second workbook based on Table number. 

Workbook1

Workbook 2

​I am trying to get information to pull from one tab to another and having issues. I believe it is because there can be multiple responses. I am trying to pull information based on table number. I have already used the following formula to pull information from this tab to a different one, but it doesn’t work for this situation because multiple lines have the same table number. =IF(ISERROR(XLOOKUP(1,’Master Seating’!H$2:H$159,’Master Seating’!K$2:K$159,)),””,(XLOOKUP(1,’Master Seating’!H$2:H$159,’Master Seating’!K$2:K$159,)))  Is there a way to edit this formula to work or another formula that I should be using.  I have attached screen grabs of the workbooks. From the first workbook I want to pull the names and allergies into the second workbook based on Table number. Workbook1Workbook 2    Read More

​