If Lookup found, search cell value based on condition in matrix
Hi Guys,
I have been researching this for the last 3 days without any luck
I have some data and a table range.
the data and range have two common values (pattern & gob grade).
If the pattern and job grade are found, i need to return the entitlement if the "service" fall between the "MIN" & "MAX" range. (see image)
screenshot.jpg
kindly help!!!
Kind regards,
Marvin.
Could you attached your spreadsheet?
Hi Tequilasunsette, hi dewik.
I'm not sure if you need a sumproduct: see the attached file.
Regards
Last edited by canapone; 06-14-2012 at 10:00 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Ciaociao,
YOU ARE A GENIUS MATE. THIS IS EXACTLY WHAT I NEEDED HELP ON.
AND THANK YOU SO SO VERY MUCH FOR THE QUICK HELP.
IS THERE ANY WAY FOR ME TO CONTRIBUTE TO THIS FORUM (PAYPAL) TO KEEP IT ALIVE?
I REALLY APPRECIATE THE WORK DONE HERE.
kind regards,
Marvin Adams.
Hi,
thanks for the very nice feedback
As you are an Excel 2007 user, you could try also in D2 and down
Greetings from Firenze
Please Login or Register to view this content.
Stefano
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks