Posted to microsoft.public.excel.misc

vlookup help pls

Posts: n/a

need to select closest match using vlookup if it higher or lower

i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value

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
Vlookup? to match column in two sheets	researcy	Excel Discussion (Misc queries)	2	February 27th 06 05:58 PM
vlookup worksheet match in macro	Joe	Excel Worksheet Functions	0	February 12th 06 12:01 AM
Match Closest Results from Data Array	TheRobsterUK	Excel Discussion (Misc queries)	2	September 29th 05 01:48 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
Closest number match help ...	NP	Excel Worksheet Functions	0	October 28th 04 09:33 AM

All times are GMT +1. The time now is 06:22 AM.

About Us

"It's about Microsoft Excel"