# Multiply one number by lookup result

1. ## Multiply one number by lookup result

Hi,

I have some surcharges for clients on one sheet and I need to multiply the net total price by this surcharge percentage.

I'm trying to get the formula in the cell (without retrieving the percentage in another column first)

I just need the lookup to search via cons. code and retrieve the percentage and multiply, if there isn't a code/ percentage it will just be blank; this is why I switched from a vlookup to an IF.

But the problem I found is that the formula only worked for my example range, of 10 clients, after this the formula isn't able to work (as the reference table only has the 10 clients going down to row 11.

I hope this makes sense! I have attached a small sample file, any help is appreciated.

Thanks!

2. ## Re: Multiply one number by lookup result

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

3. ## Re: Multiply one number by lookup result

Try this:

=IFNA(VLOOKUP(A2,Prices!\$A\$2:\$B\$10,2,0)*V2,"")

4. ## Re: Multiply one number by lookup result

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

5. ## Re: Multiply one number by lookup result

Thanks, it works perfectly!

6. ## Re: Multiply one number by lookup result

It works great, cheers and have a nice day!

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