Need help with an IF statement and Pivot

P

pdoyle

Hi

I am writing an If statement with a vlookup in the formula. a
follows:
=IF((VLOOKUP(A4,Masterdata!$A$1:$E$78,1)=A4)+(VLOOKUP($B$2,Masterdata!$B$1:$E$78,1)=$B$2),Masterdata!E3,"-")

My problem is the + sign. it should work as vlookup 1 "and" vlooku
two but the first vlookup is the overriding statement so if both don'
agree I still get a result. I need oth to agree before a set result i
returned.

Any idea
 
J

JulieD

Hi

use an embedded AND statement

=IF(AND(condition1, condition2),true,false)
=IF(AND(VLOOKUP(A4,Masterdata!$A$1:$E$78,1)=A4,VLOOKUP($B$2,Masterdata!$B$1:
$E$78,1)=$B$2),Masterdata!E3,"-")

Cheers
JulieD
 
Top