formula to return a certain Time Zone depending upon country user inputs

Hi Guys,


I was wondering if you could give me a bit of help? (Excel 2007)

I'm trying to create a formula which will return a certain Time Zone depending upon which country has been inputted.

This will be populated on 2 seperate .xlsx worksheets, the first being the Master (where all the original data is stored) and the Second being the Validation (where the user will input the data to return the ceirtain Time Zone)

I have the following formula so far: =IF(A3=""¶""¶IF(ISNA(VLOOKUP(A3¶'K:\Keith McIntyre\Documentation\[Siebel_Time_Zone_Master.xlsx]Sheet1'!$A$2:$A$699999¶3¶0))¶"Time Zone Not Found"¶"Time Zone Found"))

This basicly returns the Value Time Zone Found or time Zone not Found if the country inputted into the Validation matches the Country in the Master.

However what i require is a forumla to match the country inputted in Cell A3 of the Validation to match the Country located in the Master, and instead of returning Found or not Found, i require the ceirtain Time Zone to be returned which is located in the cell next to the country.

PLease see the following links for Images of the Master and the Validation

Unfortunately my Excel formula knowledge is very limited so i'm struggling to get the last bit

I'd really appreciate any feedback as this is really frustrating me!!!


Thank you

Keith