In the attached spreadsheet, I have a table that consist of Type, Wt & Conv. I need to find the Conv value based on matching type (B1) and closest match to wt (B2). In my example, the formula would return in cell B4 the value 4.85082. This is because the type matches the value of 1 and the Wt is rounded up to a value of 780 (B16) therefore formula returned 4.85082 which is located in C16.
How would one do this?
Thanks in advance for the help.
-Manny
How aboutFormula:
Please Login or Register to view this content.
Worked Perfectly..!
Thanks
-Manny
You're welcome & thanks for the feedback.
Maybe
=OFFSET(C1,MAX((TblConv[Type]=$B$1)*(TblConv[Wt]<=$B$2)*ROW(TblConv[Conv])),0)
Last edited by mehmetcik; 11-27-2021 at 04:44 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks