VLOOKUP & IF Formula
by ll4u76 - 11/20/12 9:02 AM
How can I create a formula that will look at two cells (one of the cells will always have N/A) and return the value of the cell that has data entered other than N/A.
Example: Cell A2 has E05 entered and Cell A4 has N/A. I want my formula to be able to determine that Cell A2 has data and return E05. Or visa versa, Cell A2 has N/A and Cell A4 has NE4, so the forumla would return NE4.
ll4u76 has chosen the best answer to his/her question.
Click here to view the answer that was selected.