Wayne G. Dengel

Posts: n/a

Appl need that VLOOKUP will not handle

I need means to locate the nearest nbr in column of nbrs that is GREATER
than the source nbr. (Did I say that right?) VLOOKUP finds the nearest
LOWEST.

nbr in question: 6.2
list of nbrs:
4.2
5.6
7.9
10.4
13.5
15.0

Entering 6.2, I would like to find 7.9 (NOT 5.6). Please how do I do this?

I am not experienced at Visual Basic, thus please need a detailed answer.

Thank You!

Wayne

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 finds a blank, but returns a zero - HELP!	flummoxed	Excel Discussion (Misc queries)	6	January 18th 05 03:15 PM
Vlookup Syntax Error	YV	New Users to Excel	9	December 23rd 04 05:28 PM
Vlookup Question	Jeff	Excel Discussion (Misc queries)	2	December 2nd 04 02:40 PM
Need help with modifying VLookUp	Tom	Excel Discussion (Misc queries)	4	December 2nd 04 12:44 AM
vlookup.	Amit	Excel Worksheet Functions	2	November 3rd 04 12:34 PM

All times are GMT +1. The time now is 05:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us