I need to use a lookup formula to have Cell X = .63 by having the formula look up the shipping rate for the extended Cost (12.50) then comparing it to the Extended $ in the lower table. Picture attached for better visual.
Extended Shipping
$12.50 Cell X
$91.45
$130.00
$37.50
$65.00
$81.00
Extended $ Rate
0 1%
10 5%
100 10%
Hi,
Welcome to the Forum.
It would be useful if you could upload sample data (insensitive) in a workbook, instead of posting screenshots. People who look into your thread won't replicate the data from images.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Assuming your data in the picture starts from A1Formula:
Please Login or Register to view this content.
Last edited by gak67; 06-05-2014 at 10:54 PM.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Is this what you need?
Welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks