| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding second value?
$1B3 thru B20 has names of people. $1C3 thru C20 has numbers. There are
some duplicate names in B3 thru B20. When I enter name in $2D4 I would like $2E4 to have number from $C3 thru C20 that matches name. More importantly, I would like $2E5 to show the second corresponding number to the same name. I can get the first match with VLOOKUP. I am having difficulty getting second number. Thanks Bobby |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding non-zero value | Excel Discussion (Misc queries) | |||
| Finding the value of x | Excel Worksheet Functions | |||
| Finding The MAX Value | Excel Worksheet Functions | |||
| Finding last used | Excel Worksheet Functions | |||
| Finding value | Excel Discussion (Misc queries) | |||
Threaded Mode
