Help with if statement (not even sure that's the best formula..)

I need help with a formula - I have attached an example of the data (Excel 2013)

I need to validate data across 4 fields and all fields will be linked to the data entered on the system for Onshore_Offshore:

If Onshore is selected then the following field, Site, should have South Africa, the City should be on the list of South African cities, and the building should be based in the right city (refer to name manager for parameters).

I've tried using an IF statement but am not getting the results I need - not sure if there's a better formula to use or if I'm just not getting it right with the IF statement (have tried multiple IF statements, constructed in various ways to include ISNA and MATCH in some).

Any sort of help with this would be most appreciated!

Birdie, welcome to the forum

While I am looking at your file, please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to, as well at your location. Members tailor answers based on your Excel version.

OK so where will you entering this data?
is what you have in that file, your "database"?

OK, so can you provide a sample of the data you are working with, and show what you expect please?

(and please, update your profile )

Birdie - which version of Excel are you using? Please do as you have been asked and update your profile to show this: it makes it easier for helpers to advise you.

OK - understood. Thanks for the information.

See attached.

Formula are similar to DV formula:

e.g.

=IFERROR(IF(MATCH(B2,INDIRECT(A2),0),""),"Incorrect Site")

I would consider changing the "India" sites to remove "India - " from the names to avoid (minimise) using the SUBSTITUTE function to match your named ranges.