One of the main functions available in Excel is the IF logic function, IF function can be combined with various other excel functions. In this example will be discussed on how to combine IF and VLOOKUP function in Excel 2003.
This post as an answer to a Friend who never asks about how to combine IF function VLOOKUP, hopefully a little give tentanng use if function in excel.
In this case, I assume in reference table there are 2 types of variables are variables that are relatively fixed and variable that changes depending on the applicable year.
In order to more easily able to make 2 pieces of the table as below:
1. Create a spreadsheet and reference the following table:
Empty cell D4 and E4 cells, because it will be filled with a formula that contains the function IF and VLOOKUP
