Vlookup with AND, OR IF statements

[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

 

[Pete_UK]

Can you try to explain what it is that you want to do?

Pete