Excel Formula for multiple criteria using VLookup

[Gerri]

Can you help with a formula?

I need a Count of records

where (Column A) (Participant) = #1, #2, or #4

and (Column B) (Jobs)) = #1

and (Column C) (First Date) is not null

and (Column D) (Second Date) is null

and (Column E) (Received Award) ≠1

and (Column) (Entry Date) <= the end of the reporting period

and (Column D) (Exit Date) >= the first date of the reporting period

or (Column F) (Exit Date) is null))

 

[vletm]

Gerri
What is Your point to use VLOOKUP to count of records?
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).

Ps. Isn't this something same as Your previous thread?

I need to use the If statement and the VLOOKUP and match to find the correct answer.

I have looked on the net but can not find what I am looking for I need to use the If statement and the VLOOKUP and match to find the correct answerer. Can you help This is my crude formula If (F2:F11) has a 1, 2, 4 Then check to see if (G2:G11) =1 Then check to see if Date in (H2:H11)...

chandoo.org

 

[Gerri]

Yes it is --- I would like help with a formula
--- I can not use a Macro or any other way but need an and if statement because I have more then one of these questions to fill out a form.
There are about 50 of these questions.
Can we use a helper column with this kind of formula.
The
IF, And, or the LEN Function to count the number of characters

 

[Gerri]

Here is another one -- Thank you for your help New File

 

[vletm]

Gerri
You skipped my question about Your need to use VLOOKUP-function.

Why cannot use a Macro?
If ... no macro ... then You could do same manually with basic Filter-option as that my macro do.

If there are as You write 50 of those then ... use 'macro'.