Question: can vlookup return a formula?
Answer: Instead of writing a nested IF, you can use a Vlookup with Evaluate function to get formulas instead of values. ... For each region we have to use a separate formula to calculate the Result (D column) from the Value (C column). The formula used for each region is mentioned in the E Column.