What exactly are you looking up? Is this a double-lookup?

Ex. Are you trying to do a Vlookup on [Daily Export .xls]Raw'!$A$1:$D$123
for the value in U5....AND a Vlookup on '[Daily
Export.xls]Raw'!$C$1:$C$123 for the word "FAX"?

Let's break it down this way:
If the name in U5 appears anywhere in the specified range of A1:A123, then
what do you want to do? Do you then want to see if the value in the
adjacent cell in column C is "FAX"?
And if both of those are true, then do you want to return the value in the
same row of column D?

If that is the case, what types of values are in column D. Are they
numbers? Will there only be one row that matches the two criteria, or could
there be more than one row? And if that is the case, then what should
happen.

Regards,
Paul


--

"Wanna Learn" wrote in message
...
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