View Single Post
  #1   Report Post  
Janice via OfficeKB.com
 
Posts: n/a
Default vlookup formula question

For the formula below,

=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes ")

What is "ISNA" and what does each value separated with comma represent?
Thanks in advance!

--
Message posted via http://www.officekb.com