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
|