That helps a lot azumi, I have never used INDEX and MATCH, how about if the drop down menu at F2 on sheet 4 had the area codes(4G and 5G) as well as the possible site codes(AZ and ZZ). Basically this will allow me to search either the area or the site with one drop down menu.

Listed like this in the drop down menu
4G
AZ
5G
ZZ