# Finding % discount via VLOOKUP

1. ## Finding % discount via VLOOKUP

Solved...............................

2. ## Re: Finding % discount via VLOOKUP

hi craigy09, your formula seems to be finding the amount after discount since you used 100%, 95%, 92% & 90% in the result_vector & multiply it by the course fees. if you wish to see the discount percentage, you should be using:
=LOOKUP( G2/7,{0,1,2,3},{0,0.05,0.08,0.1})

3. ## Re: Finding % discount via VLOOKUP

CourseFeesPaidTerm3.xlsx

Cheers

4. ## Re: Finding % discount via VLOOKUP

Oh whoops haha. Could you check this spreadsheet to make sure i did Course fee paid correctly aswell please?

Thanks for this

5. ## Re: Finding % discount via VLOOKUP

BUT you have used lookup function what ur quary says.. u need vlookup..for that you have to make a table showing in out ranges and dats it

6. ## Re: Finding % discount via VLOOKUP

Any chance you could help me out? Im completely useless with this vlookup

7. ## Re: Finding % discount via VLOOKUP

CourseFeesPaidTerm3.xlsx

done with vlookup

cheers .. if you find it helpful please click the star to the extreme left

8. ## Re: Finding % discount via VLOOKUP

Thanks! Gave you a star

9. ## Re: Finding % discount via VLOOKUP

mark this thread SOLVED.. at the top of this thread... you can only do this

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1