I think I need an IF/AND & VLOOKUP formula here

Catbert · #1 08-20-2013, 03:30 PM

I'm looking for a formula for C13 that will search Column A for the employee ID listed in A13-A17, and IF it finds that value in A1:C7 AND IF Column B says "Facial", then it will return the value from Column C for that employee's facials. If not, then it should remain blank.

Here's what I've come up with, but it's not working right.
=IF(AND(A13=VLOOKUP(A13,$A$1:$C$7,1,FALSE),VLOOKUP (A13,$A$1:$C$7,2,FALSE)="Facial",VLOOKUP(A13,$A$1: $C$7,3,FALSE)),"")

This is my first post so I hope I've attached the sample file correctly.

Any assistance with this is greatly appreciated!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup formula Problem (salary plus (commission x sales))	topgear2015	Excel	11	06-05-2013 09:02 PM
VLookup is giving me #N/A error, help with data or formula?	ladygogo78	Excel	3	10-22-2012 12:28 AM
IF + VLOOKUP formula help	skyline255	Excel	0	09-19-2012 05:05 PM
Help with VLOOKUP formula	pattyr	Excel	6	08-20-2012 02:20 AM
Using IF & VLOOKUP together	junction	Excel	7	11-18-2010 05:15 AM