| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP show all results
hi people i am working on a database. i want to use the vlookup for example..
Names age Vlookup john age john 1 1 bill 2 4 pat 3 5 john 4 7 john 5 bill 6 john 7 I want all the john age to be displayed, my database is over a thousand rows, so i was wonder if i can just select the whole entire row like B:B and it find all the ages for john only.. help plz and Thank you for your time .... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
| Line Chart - show percent and value? | Charts and Charting in Excel | |||
| Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
| Using Vlookup to compare and validate data | Excel Worksheet Functions | |||
| VLOOKUP - results do not appear in cell | Excel Worksheet Functions | |||
Threaded Mode
