Two different options to search

[Beach Walker]

Hi

Is there a simple way to search two different options, so if one option isn't found a second option is used to search with? The two options will never be present together.

See attachment, sometimes A8 can populate as either C3 or C4. The formula in D8 is only considering if it is populated as is not if A8 changes.

In the formula I am trying to implement this to is an INDEX function so the variable comes after an =, im not to sure how to work it in here.

Thanks

Eight.xlsx

[azumi]

Crosspost:

http://www.excelforum.com/excel-gene...he-result.html

[Beach Walker]

Crosspost:

http://www.excelforum.com/excel-gene...he-result.html

I think it is different to the post you reference