Thread: check if reference exists, then return its value or return 0
View Single Post
  #1   Report Post  
doudou
 
Posts: n/a
Default check if reference exists, then return its value or return 0

Hi, thanks for any answer:
In sheet 1, colB, I want to check if ref. in colA also exists in
sheet2col.A, if yes, then return its valu from sheet2col.C, otherwise
(if doesn't exist), return a 0.
Any suggestion from someone ?



--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=376567

Reply With QuoteReply With Quote