yogi_For Values In Each Row LookUp Value In Column 2 Of LOOKUP TABLE And Concatenate Resulting Values Separated By A Comma

                                           Google Spreadsheet   Post  #1969
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jun 21, 2015

question  by Naveen Nagaraja:

https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/ZVw2xo9TbaE

Google Sheet search multiple values
Hi,

I have a google sheet question

I have search data as follows

X|  Y

1 | abc

2 | def

3 | xyz

I have a row of data as follows

A| B | C

1 | 2 | 3

Now I need to search data in columns A , B and C with search data table above ( column X and Y) and then have a cell filled with value

abc,def,xyz  

How can I do this in Google sheet

Thanks,

Naveen

---

Hi Hyde,

Thanks for the information. I was looking for the first solution and it works good.

Is there a way to add a NULL check to vlookup formula ( suppose there is column D is a empty cell and I want to include it ) ?

Thanks again!!

X	Y	A	B	C	D	G
1	abc	1	2	3		abc, def, xyz,
2	def	2	3	1
3	xyz

Notice Column D is Empty but still we try to compare and then in Column G we have a , due to this .

I tried ISBLANK function but could not make it work

Naveen

-----------------------------------------------------------------------------------------------------------------------------