Greetings,
I want to create formula for data sorting in attached sheet. Want to create formula in rows 2, 3, 4 & 5 to sort from table given in right side. For example if reference dia upto 12 need to find Fα (F alpha) if module is below 1.75, below 4 & below 10. Formula must able to cover all reference diameters (from 12 to above 400) from row H5 to H23 & all modules.
Regards Manoj
Where are the "Lookup" cells for the parameters e.g Diameter and module?
Sorry John. I just cut & paste & forgot to add cell for Module & Diameter. I am attaching again sheet with Module & reference dia
Try
=INDEX($H$5:$M$25,MATCH($C$8,$H$5:$H$25,1)-1+MATCH($C$7,$I$5:$I$7,1),MATCH(RIGHT($A2,2),$H$4:$M$4,0))
Copy down
I have assumed LEAD is "Fb"
See attached
Last edited by JohnTopley; 12-20-2015 at 05:38 PM.
Greetings John,
Thank you very much. It is working.
Regards
Manoj
John,
This formula is not working for different module combinations. Can you please look into it?
Please post an example (file) showing the problem and expected results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks