Posted to microsoft.public.excel.misc

external usenet poster

Posts: 47

VLookup for greatest value

How would I add logic to this formula =VLOOKUP($A2,EXP,6,FALSE) so that it
returns the largest value if I have multiple matches in the table?

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
Greatest Number	Workbook	Excel Worksheet Functions	11	February 9th 09 03:34 AM
greatest value function?	EG	Excel Discussion (Misc queries)	2	September 4th 08 02:16 PM
Finding the greatest value	t2true	Excel Discussion (Misc queries)	4	March 21st 06 01:48 AM
Greatest to smallest	Dug	Excel Discussion (Misc queries)	3	December 4th 05 06:58 PM
Displaying Greatest to Least?	Losse	Excel Discussion (Misc queries)	2	July 14th 05 08:22 PM

All times are GMT +1. The time now is 08:59 AM.

About Us

"It's about Microsoft Excel"