You need a formula that will look to see if B2 is less than 10 If it is then you need to lookup the exact value from B2 in the table from C1 D9 and return the value from the second column If B2 is not less than 10 subtract 10 from B2 What formula could you write to accomplish this A B C IF B2 10 VLOOKUP B2 C1 D9 2 FALSE 10 B2 IF B2 10 VLOOKUP B2 C1 D9 2 FALSE B2 10 IF B2 10 VLOOKUP B2 C1 D9 2 FALSE 10 B2