Re: How do I get VLOOKUP to look for the next greater value
- From: "Paul Lautman" <paul.lautman@xxxxxxxxxxxxxx>
- Date: Mon, 12 Jun 2006 15:41:45 +0100
kingcole wrote:
I have a work*** with a bunch of pull down menus where data can be
selected and then inputed into a formula. I then want to take the
formula and automatically have a part# selected. When there isn't an
exact match VLOOKUP always selects the next lowest value, I want it
to select the next largest. This is the formula I'm using right now.
=VLOOKUP(B18,sixty,2) With B18 being the formula result, and sixty
the data range on the next work***.
Use match+index. Something like:
=INDEX(sixty,match(b18,sixty,-1))
.
- Prev by Date: Convert URL Text to Individual URL Shortcut
- Next by Date: Re: VLookup won't work
- Previous by thread: Convert URL Text to Individual URL Shortcut
- Next by thread: Re: How do I get VLOOKUP to look for the next greater value
- Index(es):
