1. Use VLOOKUP instead of nested IF statement If nested IF functions appear as puke-in-puke to you then VLOOKUP’s approximate match can help you get rid of heinously long IF statements. The only condition is to have the data in ascending order otherwise it might not work properly. Have a look at the following data: The […]