| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can VLookup function find and list multiple records?
Dear Experts,
I've a table of data and wonder whether or not it's possible to use Vlookup or Hlookup to find and list multiple rows of matching records. Please see example below: Name Supplier Cost Bk-Alpha ABC & Co 99.00 Bk-Beta 123 & Co 89.00 Bk-Apha XYZ & Co 95.00 From the above scenario, how do I go about to find "Bk-Alpha" and display all matching rows, ie: show ABC & Co, XYZ & Co and so on? I would really appreciate any kind help. Million thanks. Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
| Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
| i need a function to find the highest value in a list | Excel Worksheet Functions | |||
| how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Threaded Mode
