Works A1 here - excel 2003

=IF(ISNA(VLOOKUP(G2,IPoperations!$A$2:$F$270,6,FAL SE)), "",
VLOOKUP(G2,IPoperations!$A$2:$F$270,6,FALSE))

I wanted "nothing" instead of 0.

"JeaneIsaac" wrote:

I have a very large worksheet that I am using the following vlook up on

=IF(ISNA(VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0)),0,VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0))
I am using the results of the lookup for another calculation, so I don't
want the return value from my look up to be N/A. Can you please tell me how
to make it 0 instead of the N/A when there is no match in the lookup sheet.
Thanks