I have this formula:
=IF(ISNA(VLOOKUP(B4;'C:\WINNT\Profiles\846783\Desk top\trabalho
excel\Referencias no
total\[Parcial.xls]Sheet1'!$A$2:$F$602;6;FALSE));"";IF(ISBLANK(VLOOKU P(B4;'C:\WINNT\Profiles\846783\Desktop\trabalho
excel\Referencias no
total\[Parcial.xls]Sheet1'!$A$2:$F$602;6;FALSE));"";VLOOKUP(B4;'C:\WI NNT\Profiles\846783\Desktop\trabalho
excel\Referencias no total\[Parcial.xls]Sheet1'!$A$2:$F$602;6;FALSE)))
THAT I COPY DOWN ONCE A WEEK TO BRING UP TO DATE, THE PROBLEM IS THAT
ERASES THE RESULTS THAT WERE ALREADY THERE.
WHAT I WANTED (WHEN I COPY DOWN) IS TO IGNORE THE CELLS THAT ARE
NONBLANKS..
IDEAS PLEASE.
Thanks
--
pmarques
------------------------------------------------------------------------
pmarques's Profile:
http://www.excelforum.com/member.php...o&userid=25110
View this thread:
http://www.excelforum.com/showthread...hreadid=510969