Hi folks
I need some help in this example file that i created. What im trying to do is to search for the lowest number in column E (Cons.) using two criterias (i think). So what i was hoping to do is a formula that picks the number in K4 and rounds it to look like the ones in column C (Tir.) and then it should look for that number in column C that match, and in the same time using the number in L4 to match and than search for the lowest number in column E.
Sorry but im getting some difficulties to show my problem in words (not english guy) :-(
The result expected in this example should be the value in E14 (890) because is the lowest value that match the criteria of K4 (rounding to 310) in column C and L4 (18) in column D.
Is this possible?
Thanks for the attention
Kind regards
Bookmarks