index & match
 

A B
1 Qty Sold Rs
2 Above 20 2,023.00
3 Above 80 10,080.00
4 Above 60 20,960.00
5 Above 320 43,520.00

Above table is critera

Name Qty Sold Result
Krrish 30 I want result here by vlookup
Jay 70 I want result here by index & Math
Kis 60 Both above
Alon 200

index & match
 

Take a look at this:
http://www.contextures.com/xlFunctions03.html


Regards,
Ryan---

--
RyGuy


"krrish_a" wrote:

A B
1 Qty Sold Rs
2 Above 20 2,023.00
3 Above 80 10,080.00
4 Above 60 20,960.00
5 Above 320 43,520.00

Above table is critera

Name Qty Sold Result
Krrish 30 I want result here by vlookup
Jay 70 I want result here by index & Math
Kis 60 Both above
Alon 200