I have a list of vendors that are associated with a job. On another
spreadsheet I have that list of vendors all with their vendor number going
from 1 and up. I need a way to display the vendor numbers on the first sheet
in the same column as the vendor and the job they are associated with. I am
trying to clean up a mess and this list is huge. Suggestions?
Ex.
Sheet 1
job vendor name (need vendor number)
security A+ Security ? - need it to bring up a 3
Catering John's Deli ? - need it to bring up a 1


Sheet 2
vendor number vendor name
1 Johns deli
2 Bobs bait
3 A+ Security

Help!