I am currently having trouble trying to figure out a formula for what I am trying to do. Basically, I would like to search a list of machines that my company has by tonnage it produces and the machines that are equal to or greater than the value searched, show me what machines the value will fit in. So lets say on sheet 2, I get a value in Cell B10. I want to search the values on sheet 1 in Cells B16:B29 for the value that is in Cell B10 on sheet 2. When it find values equal to or greater than what was in Cell B10, return what machines had those given value(s).
I have attached a picture of what the cells look like.
Thanks,
Bookmarks