Posted to microsoft.public.excel.misc

sjl

external usenet poster

Posts: 8

countif w/vlookup

countif(range,criteria)
sawmill table is
10 125
12 150
14 175
i have a large range of numbers and am trying to use a vlookup in the
criteria.
i cant get this formula to work =countif(c15:c500,"<"vlookup(c8,sawmill,2))
where c8 is a value of 10, 12 or 14

thanks for any help

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 and countif???	Joe	Excel Worksheet Functions	5	March 13th 06 10:33 AM
Countif + vLookup: Can they work together?	Spyder	Excel Discussion (Misc queries)	3	February 24th 06 12:27 PM
Countif or Vlookup	praveen_khm	Excel Worksheet Functions	1	February 3rd 06 08:17 PM
Countif? or Vlookup? Lost??	leo	Excel Worksheet Functions	3	November 30th 05 02:17 PM
vlookup, sumif, if, countif, help	chintu49	Excel Worksheet Functions	0	May 26th 05 03:00 PM

All times are GMT +1. The time now is 04:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us