Help with double lookup between two files

[rhodesp]

Hello,

I'd really appreciate some help looking up some data between two files. I'm used to using vlookup but I'm unsure how to complete a lookup against two columns before returning the third item. I've attached some example data across two tabs.

I need to match upon the order number and the product, and return the relevant number of users.

Any help would be greatly appreciated.

Thank you

ExampleData.xlsx

[Ace_XL]

In Cell C2 of 'file 1'

=INDEX('file 2'!$C$3:$C$8,MATCH(1,INDEX(('file 2'!$A$3:$A$8=A3)*('file 2'!$B$3:$B$8=B3),0),0))

copy down

[rhodesp]

This is wonderful, and so prompt too Thanks so much Ace_XL