E
excelrookie
Looking for the correct Function
I have a table that looks sort of like this
A B C D E F G H I J
A 14 14 11 10 9 8 7 6 5 4
B 2 14 14 11 10 9 8 7 6 5
C 3 2 14 14 11 10 9 8 7 6
D
E Etc Etc Etc
I want to right a formula that will return the correct value in the table.
So if I enter A A then 14 if it is B A then 14 but if A B then 2. Any
idea's where I can start?
I have a table that looks sort of like this
A B C D E F G H I J
A 14 14 11 10 9 8 7 6 5 4
B 2 14 14 11 10 9 8 7 6 5
C 3 2 14 14 11 10 9 8 7 6
D
E Etc Etc Etc
I want to right a formula that will return the correct value in the table.
So if I enter A A then 14 if it is B A then 14 but if A B then 2. Any
idea's where I can start?