If cell says Not Found then give me details from another cell

[Iain Garey]

Hi All

I have two columns, column A and column B. These two columns are based on lookups to other sheets and have returned information. If the criteria within the lookup formula can't be found on these other sheets then the lookup formula in columns A and B returns "Not Found".

What I'd like is a third column which firstly looks at Column B and returns what is entered in this column, unless that column says "Not Found". If it does say not found I want the formula to then look at Column A and return what is entered here.

An example is below:-

A B New

Apple Apple Apple
Not Found Orange Orange
Pear Not Found Pear

Many thanks

Iain

[Special-K]

=IF(B1="Not Found",A1,B1)