W
Wanna Learn
Hello
Here is the formula
=if(and(Vlookup(U5,'[Daily Export .xls]Raw'!$A$1:$D$123,and,('[Daily
Export.xls]Raw'!$C$1:$C$123)="FAX" ,4, false))))
this is what I want to do
If the name appears in column U lookup in workbook 2 AND if column C has
the word FAX then answer is in column D.(also need to add and if is error
“0†)
I did not even try to add the "if error" to the formula because the one
above does not work
Here is the formula
=if(and(Vlookup(U5,'[Daily Export .xls]Raw'!$A$1:$D$123,and,('[Daily
Export.xls]Raw'!$C$1:$C$123)="FAX" ,4, false))))
this is what I want to do
If the name appears in column U lookup in workbook 2 AND if column C has
the word FAX then answer is in column D.(also need to add and if is error
“0†)
I did not even try to add the "if error" to the formula because the one
above does not work