Thread: vlookup
View Single Post
  #2   Report Post  
Old November 1st 04, 01:38 PM
duane
 
Posts: n/a
Default


=IF(D17=0,"0",if(isna(VLOOKUP(D17,ACCOUNTS!$A$1:$D $2000,4,FALSE)),
VLOOKUP(D17,NEW!$A$1:$D$2000,4,FALSE))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=274138