In range B1:B4 I'll have letters ranging from A to F. So B1 could be E and B2 could be A. These letters will always be unique.

I need an IF statement (I think) that looks for the letter B in this range and if found, returns whatever is in the cell directly to the left of it. If B is not found, then look at the letter E and if found return the cell directly to the left of it. If neither B or E are found then it should look for the letter F (which will be there somewhere) and return the cell directly to the left of it.