column B column E column H
2 29000
4 39172 29000 1255 35
5 39447 27500 975 114
6 40585 31250 985 56
7 40977 33125 1005 45
=VLookup(E$4,E$4:H$7,2)
My formula returns the 1st value regardless of whether E5,6,&7 are larger or not.
Returns 1st number(29000) whether function contains True or False as the last formula entry.
2 29000
4 39172 29000 1255 35
5 39447 27500 975 114
6 40585 31250 985 56
7 40977 33125 1005 45
=VLookup(E$4,E$4:H$7,2)
My formula returns the 1st value regardless of whether E5,6,&7 are larger or not.
Returns 1st number(29000) whether function contains True or False as the last formula entry.
Last edited: