Thread: [Solved] I think I need an IF/AND & VLOOKUP formula here
View Single Post
 
Old 08-20-2013, 03:30 PM
Catbert Catbert is offline Windows XP Office 2007
Novice
  
Join Date: Aug 2013
Posts: 5
Catbert is on a distinguished road
Default I think I need an IF/AND & VLOOKUP formula here
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!
Attached Files
File Type: xls sample sheet.xls (18.0 KB, 14 views)
Reply With Quote