Compare text columns and return a value based on text

I have a spreadsheet with 6 text columns in 2 sets. 1st set is column A,B,C. 2nd set is column D,E,F.

The columns have data populated from a drop down list.

Column A and D have the drop down options: Yes, No
Column B,C,E,F have the drop down options: Automated, Advanced, Intermediate, Basic, N/A

I want to compare column A to D; B to E and C to F and o/p a numeric value based on each comparison in column G, H & I.

i.e. compare column A to D and o/p in column G
Compare column B to E and o/p in column H
Compare column C to F and o/p in column I

Example:
A D Value to be outoput
Yes No 0
Yes Yes 1
No Yes 2
No No 3

Column B Column E Value to be outoput
Automated Automated 0
Automated Advanced 1
Automated Intermediate 2
Automated Basic 3
Automated N/A 4
Advanced Automated 5
Advanced Advanced 6
Advanced Intermediate 7
Advanced Basic 8
Advanced N/A 9
Intermediate Automated 10
Intermediate Advanced 11
Intermediate Intermediate 12
Intermediate Basic 13
Intermediate N/A 14
Basic Automated 15
Basic Advanced 16
Basic Intermediate 17
Basic Basic 18
Basic N/A 19
N/A Automated 20
N/A Advanced 21
N/A Intermediate 22
N/A Basic 23
N/A N/A 24

I have attached the spreadsheet.

Thanks.

Thanks so much Nathan ... it worked ..