Hi,

I was wondering if it is possible to have if and research in the same formula?

I need to have a fomula that looks into a cell for a certain item described
in a list and if its not there to search into a second set of data . and if
its in either to right nothing for the moment, I may need to add more later.

Thank you for your help!