Thread: [Solved] I think I need an IF/AND & VLOOKUP formula here
View Single Post
 
Old 08-21-2013, 08:43 AM
Catbert Catbert is offline Windows XP Office 2007
Novice
  
Join Date: Aug 2013
Posts: 5
Catbert is on a distinguished road
Default
I like the way you operate, BobBridges.

I've removed one paren, immediately following "Facial" and the $ from the A13 reference so I can copy the formula down:
=IF(AND(NOT(ISNA(VLOOKUP(A13,A$1:C$7,1,FALSE))),VL OOKUP(A13,A$1:C$7,2,FALSE)="Facial"),VLOOKUP(A13,A $1:C$7,3,FALSE),"")

The formula is now returning a correct value, except for Employee BAYBE, who is in the list twice, for Nail as well as Facial. How do we tweek this formula to return the value in C for the row that contains "Facial" on employees who are listed more than once?
Reply With Quote