The main sheet on my workbook has 3 fields- 'Type' , 'Data1', 'Result'
For a given row, a certain formula will be applied on 'Data1' to calculate 'Result'. The formula will vary based on the value of 'Type'.
So example if Type = A, Result= Data1*10
Type = B, Result= Data1*20.
The actual formulas are a lot more complicated.
I know this can be done using a nested if statement, but I would like to know if this can be done using Vlookup (where the formula is returned and it is applied on 'Data1')?
I don't mind any other solution as well as long as I don't need to write a long nested if statement!!
Thanks a lot....