I am in need of a macro to select the value based on two columns
value.

Below is the sample spreadsheet where my datas are arranged:

Column A Column B Column C
(City) (County)
(Factor)
ABBEVILLE HENRY 06
ABBEVILLE FD HENRY 06
ABERNANT CSA TUSCALOOSA 07
ABERNATHY CSA CLEBURNE 09
ADAMSBURG CSA DEKALB 05
ADAMSBURG CSA CHEROKEE 10
ADAMSVILLE JEFFERSON 01
ADDISON WINSTON 06
ADDISON FD WINSTON 06
ALTOONA ETOWAH 01
ALTOONA BLOUNT 07

For eg, for city "ALTOONA" and county "BLOUNT", the factor value
should return as "07". The factor value should return based on the
match of both A and B cell value.

Please help me by posting the macro for above scenario.

Thanks,
Maniarasan