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

Pete

On Nov 18, 11:26*am, Novawitt
wrote:
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