• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula for multiple criteria using VLookup

Gerri

New Member
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))
 

Attachments

vletm

Excel Ninja
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?
 

Gerri

New Member
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
 

vletm

Excel Ninja
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'.
 
Top