Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and combine all references
I have various items in a spreadsheet. Some of these items are repeated in
another row, but have a different text description for it. They all have the same reference number, just a different description. I want to combine all the descriptions into one cell. I am doing vlookup, but it is only putting in the first occurance. Can I combine all occurances into one? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and combine all references
UDF:
=rechtous(Value;RangeValue;RangeReturn) Function RechTous(v, champRech As Range, ChampRetour As Range) a = champRech temp = "" For i = 1 To champRech.Count If a(i, 1) = v Then temp = temp & ChampRetour(i) & " " End If Next i RechTous = temp End Function http://boisgontierjacques.free.fr/fi...hercheTous.xls JB On 25 mar, 20:35, BeckyB wrote: I have various items in a spreadsheet. Some of these items are repeated in another row, but have a different text description for it. They all have the same reference number, just a different description. I want to combine all the descriptions into one cell. I am doing vlookup, but it is only putting in the first occurance. Can I combine all occurances into one? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and combine all references
Thanks for your reply, but I have really no idea what the below is. Please
advise. "JB" wrote: UDF: =rechtous(Value;RangeValue;RangeReturn) Function RechTous(v, champRech As Range, ChampRetour As Range) a = champRech temp = "" For i = 1 To champRech.Count If a(i, 1) = v Then temp = temp & ChampRetour(i) & " " End If Next i RechTous = temp End Function http://boisgontierjacques.free.fr/fi...hercheTous.xls JB On 25 mar, 20:35, BeckyB wrote: I have various items in a spreadsheet. Some of these items are repeated in another row, but have a different text description for it. They all have the same reference number, just a different description. I want to combine all the descriptions into one cell. I am doing vlookup, but it is only putting in the first occurance. Can I combine all occurances into one? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Vlookup and If? | Excel Discussion (Misc queries) | |||
Combine Vlookup and Hlookup | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
how do i use the vlookup with two references ? | Excel Worksheet Functions | |||
How do I combine If and VLookup function? | Excel Worksheet Functions |