M
Mathias
Hi all,
I want to lookup a value that might not match exactly
(ranges +-2), using vlookup. I know one can use true as
last statement, but that won't work. It will always return
a value (the closestone). I want the value returned only
if it is within my range. Dget would work, but I need to
do it for over thaused rows with changeing criteria. Since
Dget always needs at least two rows for criteria, this is
not very elegant.
Any ideas???
Thanks a lot!
Mathias
I want to lookup a value that might not match exactly
(ranges +-2), using vlookup. I know one can use true as
last statement, but that won't work. It will always return
a value (the closestone). I want the value returned only
if it is within my range. Dget would work, but I need to
do it for over thaused rows with changeing criteria. Since
Dget always needs at least two rows for criteria, this is
not very elegant.
Any ideas???
Thanks a lot!
Mathias