I have Criteria 1 in column A and Criteria 2 in Column B (which are values), with the resulting condition in column B. Since column B contains numbers, if I specify value as per column A and a number which is not an exact match in column B, I do not get a result. I'm using Index and Match functions. Please refer attached file.
Any help is much appreciated.
Last edited by serene11111; 03-21-2013 at 12:04 AM.
Not sure which way you wanted to look, next highest match, or next lowest, so I offer 2
Next highest :
Formula:
Please Login or Register to view this content.
Next lowest :
Formula:Please Login or Register to view this content.
Hope this helps
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
Thank you for the quick response. It worked.
Hrrrm...Looks like i May have "jumped the gun on last post...that just gets the value from the highest Row...
Try this for next largest:
Formula:Please Login or Register to view this content.
Still looking at next lowest, but suspect it will be similar, sorry about that
For next lowest try:
Formula:Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks