Is it possible to get a Value based on 2 trues ?

[marlina]

[TABLE="width: 223"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Client Name[/TD]
[TD]Service[/TD]
[TD]Orders[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Service 1[/TD]
[TD]Orders 1[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Service 2[/TD]
[TD]Orders 2[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Service 3[/TD]
[TD]orders 3[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Service 2[/TD]
[TD]Oeders 1
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 221"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Client name[/TD]
[TD]Service [/TD]
[TD]order[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Service 3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need the order based on Name AND service.
Thank you in advance!

 

[Nine Zero]

Assuming your data begins at cell A1 and you your search values at A8 and B8 and your result in C8 input this where you want your order result

=INDEX(C1:C5,MATCH(A8&B8,A1:A5&B1:B5,0))

ALSO: This is an array formula so instead of just hitting enter make sure you do CTRL + SHIFT + ENTER when you are inside the formula bar

 

[marlina]

Assuming your data begins at cell A1 and you your search values at A8 and B8 and your result in C8 input this where you want your order result

=INDEX(C1:C5,MATCH(A8&B8,A1:A5&B1:B5,0))

ALSO: This is an array formula so instead of just hitting enter make sure you do CTRL + SHIFT + ENTER when you are inside the formula bar

You are my new favourite person.

 

[Nine Zero]

lol im guessing it worked for you

Glad i could help