Heinzpickle

Posts: n/a

Vlookup in Excel

I am using Vlookup and using lookup_values that do not have an exact match.
Vlookup automatically uses the next largest value that is less than
lookup_value. I want to use the next largest value that is greater than
lookup_value.

ex: vlookup(A1, C20-Q39, B2)
It ouputs K32, but I would like K33.

--
HeinzPickle

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
VLOOKUP function in Excel 97	M. Weber	Excel Worksheet Functions	1	January 10th 05 07:46 PM
Excel Problem: VLookup	andyp161	Excel Worksheet Functions	1	November 18th 04 12:29 PM
vlookup function in excel referencing an access table	AJN	Excel Worksheet Functions	1	November 7th 04 07:09 PM
using a reference in vlookup with excel 2003	Gord Dibben	Excel Worksheet Functions	0	October 28th 04 01:27 AM

All times are GMT +1. The time now is 12:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us