Catalog

Hello. I'm new to both excel and this forum, so I'm not entirely sure where to post this inquiry. Within my department, at work, we dispatch technicians to varying sites. We have a rather large collection of vendors, for varying purposes, for varying sites. How would I create an excel document where I could input a site name in a cell and have other cells populated with the correlating vendors and contacts.

simiple use vlookup formula..

if you not understand kindly upload your dummy file..