Sorry, should be

=COUNTA(INDIRECT("B1:B"&MATCH(D1,A1:A7,0)))


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ronbwa" wrote in message ...
| Is it possible to use VLOOKUP and COUNTA in the same formula? I want to find
| a value with VLOOKUP and then I want to count entries in column up to and
| including value found with VLOOKUP.