Hi,
In Excel 2003 I am trying to return a unique value against 2 possible options.
I have a table of reference;
Col A Col B Col C
W (W) 3
1 (1) 9
1c (1c) 6
1b (1b) 9
1a (1a) 11
2 (2) 15
2c (2c) 13

etc

In the s/sheet used, a value from Col A or Col B will be entered so I want a
formula in the next column to return the relevant value from Col C. (eg, if
1a or (1a) = 11).

Greatful for any advice.
Cheers
snakey