Lookup sort of thing!
I would appreciate some help with what I think is a form of lookup function
in Excel.
I have added two cells in a worksheet, One showing contractor name and one
next to it showing Contractor ID number. The data for both these cells needs
to come form a lookup list.
I have a lookup list in one column showing the contractor name for test
purposes showing:
Contractor 1 1234
Contractor 2 2345
Contractor 3 4456
Contractor 4 5656
Contractor 5 5656
Contractor 6 7878
In the column next to this I have listed the Contractor ID numbers.
The Contractor name cell uses the Validation list function to show a
dropdown from the lookup table of contractors. My question after all this
babble is how do I get the Contractor ID Number cell to automatically display
the correct number when a Contractor is selected form the Contractor Name
dropdown?
Any advice pointing me in the right direction would be great!
|