Try
=COUNTIF(C15:C500,"<"&VLOOKUP(C8,sawmill,2))
Regards,
Alan.
"sjl" wrote in message
...
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