Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comma seperated values using multiple vlookup
Hello at the moment I have cells like this:
=VLOOKUP(B28,Generics!A3:AZ255,12,FALSE) BCM200_10AGT =VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE) BCM50_KC0236 As you can see some contain values and others contain formula's to values. At the moment I am getting the following to work: BCM50_KC0236, BCM50_KC0237, BCM50_KC0238 but I would eventually like to get the same working for the above formula's. Something like the following will not work: =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE), VLOOKUP(B28,Generics!A3:AZ255,12,FALSE), VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) Which ideally would give me the values seperated by a comma. Perhaps its not possible, can someone please let me know if its possible, or am I just going about it all wrong. It has to be like above in order to work with the code that is written (I know I could just use more cells, but in this situation I need comma seperated values a cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
comma seperated values using multiple vlookup
Hi, not sure if this is what you are looking for but you could try
=VLOOKUP(B28,Generics!A3:AZ255,15,FALSE)&", "&VLOOKUP(B28,Generics!A3:AZ255,12,FALSE)&", "&VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) Hope this helps Stu "TheSniipe" wrote: Hello at the moment I have cells like this: =VLOOKUP(B28,Generics!A3:AZ255,12,FALSE) BCM200_10AGT =VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE) BCM50_KC0236 As you can see some contain values and others contain formula's to values. At the moment I am getting the following to work: BCM50_KC0236, BCM50_KC0237, BCM50_KC0238 but I would eventually like to get the same working for the above formula's. Something like the following will not work: =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE), VLOOKUP(B28,Generics!A3:AZ255,12,FALSE), VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) Which ideally would give me the values seperated by a comma. Perhaps its not possible, can someone please let me know if its possible, or am I just going about it all wrong. It has to be like above in order to work with the code that is written (I know I could just use more cells, but in this situation I need comma seperated values a cell. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
comma seperated values using multiple vlookup
stumac, ur a genius, thanks a million mate, that worked like a dream
"stumac" wrote: Hi, not sure if this is what you are looking for but you could try =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE)&", "&VLOOKUP(B28,Generics!A3:AZ255,12,FALSE)&", "&VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) Hope this helps Stu "TheSniipe" wrote: Hello at the moment I have cells like this: =VLOOKUP(B28,Generics!A3:AZ255,12,FALSE) BCM200_10AGT =VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE) BCM50_KC0236 As you can see some contain values and others contain formula's to values. At the moment I am getting the following to work: BCM50_KC0236, BCM50_KC0237, BCM50_KC0238 but I would eventually like to get the same working for the above formula's. Something like the following will not work: =VLOOKUP(B28,Generics!A3:AZ255,15,FALSE), VLOOKUP(B28,Generics!A3:AZ255,12,FALSE), VLOOKUP(B28,Generics!A3:AZ255,14,FALSE) Which ideally would give me the values seperated by a comma. Perhaps its not possible, can someone please let me know if its possible, or am I just going about it all wrong. It has to be like above in order to work with the code that is written (I know I could just use more cells, but in this situation I need comma seperated values a cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List cell values seperated by comma if criteria met | Excel Worksheet Functions | |||
Find the sum of Comma Seperated Values In a Cell | Excel Worksheet Functions | |||
Sum of comma seperated values in cell(Reposting) | Excel Worksheet Functions | |||
column values to a cell with comma seperated | Excel Worksheet Functions | |||
parameter has multiple values seperated by value | Excel Programming |