Instead you can use a combination of Vlookup and Evaluate function to do the task, It will be very easy to edit the formula if you want to make any changes to the calculation.ĮVALUATE is an Excel v4.0 macro function which is still supported in Excel. Then IF function will be too long and it will be difficult to maintain, editing will be a real pain. But if you have more regions, say more than ten. You can use a simple IF function like this to find out the answer, =IF(B2=”East”,C2*9/75,C2*8/85). The formula used for each region is mentioned in the E Column. For each region we have to use a separate formula to calculate the Result (D column) from the Value (C column). To make it simple purpose I have created the data with only two regions East and West. E column is shown in the picture for you to understand the formula used in D column. The downloaded file will look like this image given below without the last column.
#How to link cells in excel using vlookup download
Download the Excel sheet from the link given below to follow along. We will go through an example for you to understand. Instead of writing a nested IF, you can use a Vlookup with Evaluate function to get formulas instead of values. What if you want to check so many IF conditions, in this case you will write a big nested IF, which will be very difficult to maintain and will be very difficult to understand.
You might be writing so many IF function to check a condition is true, and if the conditions are met you will write a formula for that. The Evergreen and Versatile Vlookup formula If you don’t know Vlookup function here is the link to my post. But this time we are looking for an alternate for nested IF function using Vlookup and Evaluate function. In this post we are again discussing Vlookup function.