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

[marlina]

Client Name	Service	Orders
Kevin	Service 1	Orders 1
Kevin	Service 2	Orders 2
Kevin	Service 3	orders 3
John	Service 2	Oeders 1

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

Client name	Service	order
Kevin	Service 3

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

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