-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Had a problem and fixed it
- Thread starter rich952
- Start date
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hello, rich952,
Since you found what you needed and didn't post a real question there was great chance that noone would ever say to you ...
Welcome to the Board ! !! !
ENJOY IT!!
Erik
Since you found what you needed and didn't post a real question there was great chance that noone would ever say to you ...
Welcome to the Board ! !! !
ENJOY IT!!
Erik
Tazguy37
MrExcel MVP
- Joined
- May 28, 2004
- Messages
- 4,237
At the risk of sounding like an echo... Welcome!
Glad you found what you needed. I'm sure that in no time, you'll be posting solutions more often than asking questions.
This board wouldn't be the outstanding resource that it is without people willing to donate their time and effort to post answers.
My parting advice: Check my sig! You'd be very surprised how knowledgeable you can get on a subject if you stick to that.
Not the XL2003 thing...I'm _very_ slowly coming to terms with this version.
Glad you found what you needed. I'm sure that in no time, you'll be posting solutions more often than asking questions.
This board wouldn't be the outstanding resource that it is without people willing to donate their time and effort to post answers.
My parting advice: Check my sig! You'd be very surprised how knowledgeable you can get on a subject if you stick to that.
Not the XL2003 thing...I'm _very_ slowly coming to terms with this version.
, so I guess I'll be stuck testing your code in 2000. :wink:
