Formula for matching conditions

[justinjerome]

Hi,

See the attached file.

I need a help to find out the formula for Matching two conditions, and showing the result.



Thanks
Justin

[shg]

Please take a few minutes to re-read the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.

[shg]

Thank you, Justin.

[shg]

	B	C	D	E
4	Emp#	Days worked	Project Name
5	19	1	LOC	D5: {=INDEX(DATA!$F$2:$F$5, MATCH(1, (DATA!$B$2:$B$5=B5) * (DATA!$E$2:$E$5=C5), 0))}

The formula MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.

It's not a very robust approach, though -- surely there could be duplicates, and this would only find the first match.

[justinjerome]

Thank you very much for your immediate support.

[shg]

You're welcome.

[Scavenger102]

Morning everyone,

I have a bit more complicated spreadsheet, or at least trying to create.

It would also have to show results that matched 3 conditions but from different sheets depending on choice from drop down menu.

And now I want to show results using drop down menu for electricity and cost for year 2014-15 in cells E3 to P4 in sheet HOME if that makes any sense

[AliGW]

Welcome to the forum!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

NOTE: no help to be offered to Scavenger102 in this thread, please. Thanks!

[Scavenger102]

Sorry, I will start a new one

[AliGW]

Thanks.

[Regality]

Use the INDEX MATCH formula to get your result.
{=INDEX(range, MATCH(lookup_value_1&lookup_value_2&..., lookup_range_1&lookup_range_2&..., match_type))}

You can get more information from this link: https://www.deskbright.com/excel/using-index-match/