[Solved] Why is this IF formula only half working?

[Captain Crack]

Frustration is rather high here at the moment.

I have got an IF formula that only half works and I'm struggling to understand why...

=IF(B4="1A";Lots.E3;IF(B4="1B";Lots.E4;IF(B4="1C";Lots.E5;IF(B4="2";Lots.E6;IF(B4="3";Lots.E7;"")))))

Where "Lots" is another work sheet where the table with the raw data is.

Now if I enter a number and letter into B4 the formula works but if I just enter a number the cell remains blank.

eg... enter "1A" into B4 the cell say C4 comes up with the answer of 22, but if I enter just "2" I get a blank cell. (obviously without quotation marks)

I could change "2" in the formula to C137 and it will work but not with the number by itself.

Please help before I go any more bald!

[gerard24]

Remove double quotes around numbers in your formula.

2 is the number two, "2" is the text 2 and they are not equal.

[Captain Crack]

Holy Cheese Balls!! So simple and obvious, thanks for that