I have 2 columns in sheet1, Division and Branch. Based on these two columns i
need to populate the state in a column "STATE". I have a table with branch n
divisions by which state could be derived. Detailed layout is below:

Sheet1

Branch Division STATE
041 0039 ?
041 0001 ?

Mapping Table:
Branch DIV State
041 0001 NY
041 0003 ATL
041 0008 FL
041 0010 CA
041 0015 NY
041 0021 NY
041 0023 NY
041 0024 NY
041 0026 MA
041 0027 PA
041 0030 MA
041 0031 MA
041 0038 MA
041 0039 ATL

So, i need a formula n my sheet1 which has a condition if sheet1branch=41
and div=39 then ATL etc (Conditions vary as per mapping table). i cant do
every value since there are a lot of records in the mapping table. Can anyone
tell me how to do this? ANY HELP WLD BE APPRECIATED!...THANKS