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
ryguy7272 - 16 May 2008 19:39 GMT
Take a look at this:
http://www.contextures.com/xlFunctions03.html
Regards,
Ryan---

Signature
RyGuy
> A B
> 1 Qty Sold Rs
[quoted text clipped - 11 lines]
> Alon 200
>