Thread: How do I only get valid "answers" in a VLOOKUP function (no #N/A's
View Single Post
  #5   Report Post  
 
Posts: n/a
Default
Hi,
try to use ISERROR function:

=IF(ISERROR(VLOOKUP(A1;Sheet1!$A$2:$C$11;2;0));0;V LOOKUP(A1;Sheet1!A2:C11;2;0))

Marian
http:\\skolenieexcel.host.sk

Reply With QuoteReply With Quote