Q:

Lookup value to match conditions

I've searched quite a while but can't find a correct answer. 
As image shown below, I'd like to to find the value of Book name is Red book, and Category is Novel. I found vlookup can't match multi conditions, could someone please advice what function should I use? 
So like
if (Book name == "Red book" && Category == "Novel") {

    get "in Stock" value // which is 4 
}

Thanks

A:

Try this: 
    =ARRAYFORMULA(VLOOKUP("Red Book"&"Novel",{A1:A500&B1:B500,C1:C500},2,0))

