Vlookup with AND, OR IF statements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top