Sunday, June 21, 2015

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!!

XYABCDG
1abc123abc, def, xyz,
2def231
3xyz


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
-----------------------------------------------------------------------------------------------------------------------------