Help please -I need to lookup 2 criteria the first needs to be exact but the second needs to be within a range.
Help please -I need to lookup 2 criteria the first needs to be exact but the second needs to be within a range.
we are not mind readers, nor do many of us have crystal balls.
please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
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
Sorry, hopefully, I've got there eventually.
The yellow column is what I'm trying to get.
Last edited by geebers97; 06-23-2015 at 02:27 PM.
The yellow column is what I'm trying to get.
Last edited by geebers97; 06-23-2015 at 02:27 PM.
Where did the amount in the cost column come from and how is it related to the ranges 1 and 2?
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
Is this what you want?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
in yellow the helpcells.
in green the result.
You added the wrong result in L7 (shoud be 38 instead of 37).
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Columns I and J (cost) are on a separate sheet and I need to find the discount that would be given (yellow column), based on the entity and cost.
Your example was just 1 sheet.
Adjust the formula and it will work
well if you have data on other sheets that needs to be referenced, dont you think it would help if you included those sheets?
Thank you guys for such fantastic responses and so quickly, much appreciated.
I had an issue with rounding and popipipo's solution eliminated this.
Thanks again!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks