Forum Discussion
Excel formula help
Hi new to excel What I am looking to do is build a calculator that has variables . I think it will be a vlookup but don't know how to do it . calculator is a variable pricing one variables are ...
Hi
Thank you for the info if I didn't want to times & just replace with a set value
say 1-10 = 34
11-20 =40
21-30=54
31-40 =60
how would I edit the formula ?
many thanks Dan
Hi Dan,
Simply, remove the multiplication part from the formula as follows:
=VLOOKUP(A2,E2:G6,3)
Regards,
Haytham