Forum Discussion

José Lorenzo Strédel García's avatar
José Lorenzo Strédel García
Copper Contributor
Apr 20, 2018

Excel formula

Hello,   I am struggling in creating a calculator with the following information: VOLUME OF USERS Professional Corporate Enterprise User/month  User/month User/month From 10 to 50 us...
Formulas & Functions
Tutorial
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 20, 2018

Hi José,

 

To make the solution as easy as possible, you have to redesign the table as follows:

 

After that, you can use this formula in cell C12:

=VLOOKUP(B12,A3:E7,MATCH(A12,C1:E1,0)+2)

 

Please find the attached file.

 

Hope that helps

Haytham

Resources