I am trying to build an IF statement that would apply and I could copy
accross as a formula. I want to include in the cell C3 an IF query that would
populate the cell based on the value in Column B3, B4, B5 etc.

If the cell in Column B is "c" then I need to return a value 3, if it is "d"
then return a value 4, if it is "e" then return a value 5. There could be
multiple iterations in the same column, multiple a/b/c/d etc. Then in the
next cell (column) have the same function? Hope this makes sense
ROW c d e f g h
COLUMN
3 c 3 3 3 3 3 3
4 d
5 e
6 f
7 g
8 h
9 c 9 9 9 9 9 9
10 d
11 e
12 f
13 g