Excel 2010 doesn't seem to want to handle this?
=IFERROR(VLOOKUP(A125,sheet1,4,FALSE),VLOOKUP(A125,sheet1,2,FALSE)).
In other words, If there is a value in column 4 of the lookup table, use it, otherwise use the value in column 2. Excel 2010 accepts the syntax. The result in the cell is the...