| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup function return all values
My table for vlookup: A1:B4
1110 2 or it can have one key 1110 2 1110 3 3 1120 4 1120 4 1120 5 5 I need the function to return all data associated with the value. so when I look up 1110, i get 2 and 3 in different cells such as 2 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| How do I sum a range which includes the "#N/A" VLOOKUP return valu | Excel Worksheet Functions | |||
| VLOOKUP Function | Excel Worksheet Functions | |||
| Return value with using Excel function | New Users to Excel | |||
Threaded Mode
