Vlookup with AND, OR IF statements

  • Thread starter Thread starter Novawitt
  • Start date Start date
N

Novawitt

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
 
Back
Top