Thread: [Solved] I think I need an IF/AND & VLOOKUP formula here
View Single Post
 
Old 08-21-2013, 12:25 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
I must admit I did not have the courage to read all the preceding posts so I may have missed something

The following should do what you need ( based on your first post AND if you are using XL2007 as stated). It does have to be entered as an array formula with Ctrl+Shift+Enter and you'll have to change the " facial" part if needed

Code:
=IFERROR(INDEX($C$2:$C$7,MATCH(1,($A$2:$A$7=A13)*($B$2:$B$7="Facial"),0)),"")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote