multiple functions

[ronbwa]

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.

 

[Niek Otten]

With your data in A1:B7 and your search argument in D1:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.

 

[Niek Otten]

Sorry, should be

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.