Hi Friends,
Here is the data which I am trying to vlookup but did get a formula to that
<colgroup><col span="2"><col><col><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>
I want to vlookup and find a match of ColumnR within a Column Range F:Q and return first and last name of that row in ColumnS and ColumnT
Thanks
Satish
Here is the data which I am trying to vlookup but did get a formula to that
ColumnA | ColumnB | ColumnC | ColumnD | ColumnE | ColumnF | ColumnG | ColumnH | ColumnI | ColumnJ | ColumnK | ColumnL | ColumnM | ColumnN | ColumnO | ColumnP | ColumnQ | ColumnR | ColumnS | ColumnT |
Ray | Chu | R | C | @co.westmoreland.pa.us | Ray.Chu@co.westmoreland.pa.us | RChu@co.westmoreland.pa.us | Ray.C@co.westmoreland.pa.us | R.Chu@co.westmoreland.pa.us | Chu.Ray@co.westmoreland.pa.us | Chu.R@co.westmoreland.pa.us | C.Ray@co.westmoreland.pa.us | RayChu@co.westmoreland.pa.us | RayC@co.westmoreland.pa.us | ChuRay@co.westmoreland.pa.us | ChuR@co.westmoreland.pa.us | CRay@co.westmoreland.pa.us | Lacey.Peterson@wvjc.com | ||
Deanna | Gunlefinger | D | G | @drinkerbiddle.com | Deanna.Gunlefinger@drinkerbiddle.com | DGunlefinger@drinkerbiddle.com | Deanna.G@drinkerbiddle.com | D.Gunlefinger@drinkerbiddle.com | Gunlefinger.Deanna@drinkerbiddle.com | Gunlefinger.D@drinkerbiddle.com | G.Deanna@drinkerbiddle.com | DeannaGunlefinger@drinkerbiddle.com | DeannaG@drinkerbiddle.com | GunlefingerDeanna@drinkerbiddle.com | GunlefingerD@drinkerbiddle.com | GDeanna@drinkerbiddle.com | Williams.Jemile@norristown.org | ||
Jemile | Williams | J | W | @norristown.org | Jemile.Williams@norristown.org | JWilliams@norristown.org | Jemile.W@norristown.org | J.Williams@norristown.org | Williams.Jemile@norristown.org | Williams.J@norristown.org | W.Jemile@norristown.org | JemileWilliams@norristown.org | JemileW@norristown.org | WilliamsJemile@norristown.org | WilliamsJ@norristown.org | WJemile@norristown.org | Gunlefinger.Deanna@drinkerbiddle.com | ||
Lacey | Peterson | L | P | @wvjc.com | Lacey.Peterson@wvjc.com | LPeterson@wvjc.com | Lacey.P@wvjc.com | L.Peterson@wvjc.com | Peterson.Lacey@wvjc.com | Peterson.L@wvjc.com | P.Lacey@wvjc.com | LaceyPeterson@wvjc.com | LaceyP@wvjc.com | PetersonLacey@wvjc.com | PetersonL@wvjc.com | PLacey@wvjc.com | RayC@co.westmoreland.pa.us |
<colgroup><col span="2"><col><col><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>
I want to vlookup and find a match of ColumnR within a Column Range F:Q and return first and last name of that row in ColumnS and ColumnT
Thanks
Satish