Hello everyone! I need your help in writing a formula for my table.
Untitled-1.jpg
I need a formula to check which RANGE column F belongs to and have the correstponding RATE show up in column G. Is it possible to include conditions for all 7 ranges in 1 formula?
Explain the method to compare the F value to arrive the Rate?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi snooks and welcome to the forum,
You need to learn Index and Match formulas. See the attached for what I think you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
AND screenshots are (almost) worthless...next time try a sample workbook
Add a File - click advanced (next to quick post), scroll down until you see "manage attachments", click that and select "add files" (top right corner). click "select files", find your file, select file, click "upload", when the file shows up at the bottom left click 'done"(bottom right). click "submit reply"(remember the 1 MB limit, you may have to crop your file down to get it to a size that can be uploaded...)
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Or
In G2 cell - To Get the Rate
Formula:
Please Login or Register to view this content.
OR
In G2 cell - To Get the Range
Formula:Please Login or Register to view this content.
Drag it down...
MarvinP thanks! This is what I need! Thank you very much! Will have to do some studying on Excel formulas. Thanks again!!
Thank you both for your quick reply
dredwolf a sample workbook was attached to my first post
Yes, I understood the logic from MarvinP formula and just posted another alternativeOriginally Posted by snooks
My Bad...did not see that..sorry
Thanks again! Will try what you posted as well as ^__^Yes, I understood the logic from MarvinP formula and just posted another alternative
It's ok dredwolf ^__^ no problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks