Posted to microsoft.public.excel.misc

Huber57

external usenet poster

Posts: 74

VLOOKUP to Find the MIN (that is not zero)

All:

I am stumped on this.

I have combed through the archives and cannot find the answer

I need to return the minimum price for an item (where the price is not zero)

Item Price Vendor
Apple $1 Wal-Mart
Apple $2 Target
Apple Sears

I need the formula to return $1.

=IF(MIN(VLOOKUP("Apple",B2:B4,FALSE)))

is definitely not working.

Thanks,

Doug

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 Find one value but exclude another	MS-Exl-Learner	Excel Discussion (Misc queries)	0	September 9th 09 10:56 AM
I can't find vlookup values!	ragtopcaddy via OfficeKB.com	Excel Worksheet Functions	3	November 13th 07 02:11 PM
Use Vlookup to find less than today	Bruce	Excel Worksheet Functions	3	April 26th 06 10:05 PM
Vlookup & Find	Caroline	Excel Worksheet Functions	2	April 7th 06 03:13 PM
How do i use vlookup to find more than 1 entry	Shaum	Excel Worksheet Functions	3	March 18th 05 04:49 PM

All times are GMT +1. The time now is 05:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us