| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question - bring in all values?
I believe vlookup is set to bring in the first match in the range. But is it
possible to bring in all matches and display them in a list separated by commas? So: A Yellow B Red C Green B Blue D Purple B Orange E Black Input into D1 =+vlookup("B",A1:B7,2,FALSE) will retrieve "Red." Is there a formula to use that will bring in (Red, Blue, Orange) - all into D1?? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bring values in a column into a row | Excel Worksheet Functions | |||
| Vlookup, Bring up certain Info. only??? | Excel Discussion (Misc queries) | |||
| Vlookup, Can I only have it bring up a transactions once? | Excel Discussion (Misc queries) | |||
| Can you use a vlookup to bring in a picture? | Excel Discussion (Misc queries) | |||
| How can I bring forward formats with Vlookup? | Excel Worksheet Functions | |||
![Kevin W[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
