Using the attached file, the formula that I currently have in cell A22 returns a result in cell A20 that exactly matches an amount in my data table. I want to be able to modify this formula to also have the ability to lookup an amount such as $1.20 and return $.10, the amount in Col C that relates to a value that cannot be higher than the amount entered (i.e. $1.25 is > $1.20 so $.25 cannot be returned, $1.10 is < $1.20, therefore $.10 is returned).
Question.xls
hi Kraftyk, welcome to the forum. i dont really understand the explanation, but i'm guessing this is what you need:
=LOOKUP(2,1/((A2:A15=B22)*(B2:B15<=A22)),C2:C15)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
HI,
I Have one Doubt . May i know how Lookup Works.
By Vengat
vengat, Welcome to the Forum.
I dont see how your question is relevant to answering the OP's question?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
Thanks, this is exactly what I was looking for!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks