View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Novawitt Novawitt is offline
external usenet poster
 
Posts: 3
Default Vlookup with AND, OR IF statements

Hi there I have a database type file using excel

several cells use the equation

=IF(ISNA(VLOOKUP(A6,Contacts,6,FALSE)),"",(VLOOKUP (A6,Contacts,6,FALSE)))

contacts being a reference to a spceific area within a different sheet.

Can this same equation be modified to include reference to a different cell
on a different sheet using AND or OR.

Thanks in advance