Hi all, Newbie with Excel and looking to create a dispatch database. I was told Vlookup was the function of choice. See table below:
What I want to do is have a 3 colums to the left of this hidden data with CITY, PRIMARY & 2NDARY as headers. A1 - City & Then B1 & C1 will provide the details from F1 & G1
I'm assuming this is simple but I can't seem to grasp the Vlookup tool. For all I know there is a better tool. All I do know is that using any VB coding is out of scope for me. Hoping this can be done with a couple of formulas.
Any assistance would be greatly appreciated.
E F G
CITY PRIMARY 2NDARY
<colgroup><col><col><col></colgroup><tbody>
</tbody>
What I want to do is have a 3 colums to the left of this hidden data with CITY, PRIMARY & 2NDARY as headers. A1 - City & Then B1 & C1 will provide the details from F1 & G1
I'm assuming this is simple but I can't seem to grasp the Vlookup tool. For all I know there is a better tool. All I do know is that using any VB coding is out of scope for me. Hoping this can be done with a couple of formulas.
Any assistance would be greatly appreciated.
E F G
CITY PRIMARY 2NDARY
Alma | Progitech | None |
Amos | Progitech | None |
Ancienne-Lorette | Elias | Microage QC |
Ancienne-Lorette | Elias | Microage QC |
Ange-Gardien | Gilberto | Jason |
Anjou | New Hire | Jason |
Anjou | New Hire | Jason |
Asbestos | Elias | Progitech |
Ascot-Corner | Progitech | Microage QC |
Ayers Cliff | Gilberto | Progitech |
Ayer's Cliff | Gilberto | Progitech |
Ayer's Cliff | Gilberto | Progitech |
Baie Comeau | Progitech | None |
Baie Comeau | Progitech | None |
Baie Comeau | Progitech | None |
Baie Comeau | Progitech | None |
<colgroup><col><col><col></colgroup><tbody>
</tbody>