How do I create the if (or and?) formula that ensures when two cells (A and B) in sheet 1 have values typed in, it looks ups and displays data from 4 columns(in sheet 2) in columns C D E F in sheet 1.
There will always be data in sheet 2 entered in.
Any ideas?
Bookmarks