Hey Guys,
im having the following problem. I want to match a value that is closest in value to the lookup value and also fulfils some other criteria.
The first criteria is a number that I want to match with the item that is closest in value in cell AL457. For this, the following formula works.
But now I want to find the cell that is closest in value and fulfills another criteria, which is in cell DT457. However, if I use the following formula below, this only works if the item that is closest in value also fulfills the criteria. If it doesnt, I get #N/A. Lets say that the first item that fulfills the criteria is 3rd closest in value, than thats the item I want to know the row of.
Help would be greatly appriciated!!!!
Thanks!
Oh, Excel 2007 btw
Bookmarks