Is this a VLOOKUP function?

[paulh267]

I want to pull information from cell AQ into cell P2 IF it contains the information in cells K to O that is the same as K2 to O2.

I've tried using =VLOOKUP( AND(K2, L2, M2, N2, O2), AND(K:K,L:L,M:M,N:N,O:O ), AQ:AQ ) but with no luck (as you can probably tell I'm new to using it).

Is VLOOKUP the correct function for this purpose? Any help is greatly appreciated on this as I'm still relatively new to Excel