View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ddjlddjl ddjlddjl is offline
external usenet poster
 
Posts: 1
Default Vlookup help with function

I need to perform the following lookup and comparison: On sheet 1, if content
in a1:a700 AND content of b1:b700 AND content of c1:b700 matches exactly to
Sheet 2, content in a1:a700 AND content of b1:b700 AND content of c1:b700,
then return value in d1:d700 from sheet 2, if no match, return 0 (zero).