Need to use vlookup to find 2 matches

Basically I need to find a match in column A and if it finds that match find a match in column B then return the value of lets say column C. Thanks in advance for any help.

Insert a new col C
Concatenate columns A & B into it (i.e. = Ax & Bx)
lookup the concatenated value in the concatenated column in Col D
Hide Col C

Job done

Another way is =if(and(a1=value1;b1=value2),c1,"")
Adapt the values and cells to your needs
HTH

=SUMPRODUCT((A1:A20="Sent TP")*1;(B1:B20=B1)*1)

Explination:
(A1:A20="Sent TP") will return an array of 20 values either True or False
By multiplying these with 1 the array changes to value with either a zero (0) or a one (1)
Sumproduct does nothing else then multiplying these new arrays

Do not forget to press Ctrl+Shift+Enter when you have entered the formula to make it an Array Function

Cheers,
R