Need help about multiple IF

[Waqas Gul]

Dear Excelforum Family and Experts,

i need help about how to combined multiple IF, attached sheet is for reference. i have a data sheet which is Column wise where i have another sheet which is row wise data. i need multiple IF formula to collect data from Data sheet. i have created a formula but don't know to add another IF formula.

i have IN OUT Data sheet. from which i have required if someone is present than which time the person have OUT and that show me the time.

Thanks in advance.

[Glenn Kennedy]

In C2, coped across and down:

=IFERROR(INDEX(Data!$D$3:$D$19,MATCH(1,INDEX((Data!$A$2:$A$18=Sheet2!$B2)*(Data!$C$2:$C$18=Sheet2!C$1)*(Data!$E$2:$E$18="In"),0),0)),"A")

Note the overlapping ranges (red and blue)

[Waqas Gul]

In C2, coped across and down:

=IFERROR(INDEX(Data!$D$3:$D$19,MATCH(1,INDEX((Data!$A$2:$A$18=Sheet2!$B2)*(Data!$C$2:$C$18=Sheet2!C$1)*(Data!$E$2:$E$18="In"),0),0)),"A")

Note the overlapping ranges (red and blue)

Really thanks for your quick help Glenn Kennedy, need one thing how do i add if there is someone IN OUT not available in any date than show me Absent.. if it is possible, please.

Thanks alot.

[Glenn Kennedy]

Im away from my PC. However I don't understand your request. Please upload a modified sheet showing what you expect to see and where you expect to see it.

[Waqas Gul]

Really thanks for your reply Glenn,

i am attaching the file for reference, if it is possible will really thankful to you.

Thanks.

[Glenn Kennedy]

I hope you don't dream up any more conditions.... this is getting ugly!!

[Waqas Gul]

I hope you don't dream up any more conditions.... this is getting ugly!!

Wow... Really Really Thanks Glenn. You really solve my problem.

Once again really Thanks. SOLVED

[203]

Multiple IF statements. I am trying to arrive at a price model that will show what the licensing fees will be based on the number of users.

Specifically, the first 5000 users are no charge ($0), users 5001-9999 are $20 per user and users over 10,000 is a flat fee of $100,000.

The number of users is calculated on a 12 month look back starting after the 19th month.

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[203]

Ali,

I don't believe my post references any of the above issues. Nevertheless, do I need to start a new thread?

[AliGW]

Absolutely - you cannot piggy back an existing thread with your own questions!!! Please don't post to this thread again - start your own. Thanks.