I would like to look up a value in columnns b,d,f etc and return the
corresponiding value in the adjacent column c,e,g

B C D E F G
2 30000 A 30150 b 30300 c
3 30200 a1 30351 b2 30502 b3