Finding the solution to an Exel problem.
 

My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP'
functions and they return a value when certain criteria are met. There are
only 4 value scenarios that can occur. 1) Both cells have no response and a
'#N/A' is displayed in each cell. 2) Both cells have the same response,
(ie:'XT25' & 'XT25'). 3) The first cell has a response, (ie:'XT25') and the
second cell displays '#N/A'. 4) The first cell displays '#N/A' and the
second cell has a response, (ie:'XT25'). What I would like to do is simply
display any response other than '#N/A' only once in a third cell. In this
case, other than the 1st scenario ( both cells w/ '#N/A'), I would want
'XT25' displayed in the cell by itself (just 'XT25', not 'XT25,XT25' or
'XT25,#N/A'). I've exhausted my thoughts with 'IF', 'OR', and 'CONCATENATE'
functions and have failed. I keep getting 'Value' error responses. Is the
'#N/A' error the root of my problems when it is displayed. Even before a
condition occurs, '#N/A' is being displayed in the 2 adjacent cells. It
would seem like there would be an easy answer to this, is there?
--
Whoever has the correct answer, Thank You for knowing and caring.

Finding the solution to an Exel problem.
 

=IF(NOT(ISNA(A1)),A1,IF(ISNA(B1),"",B1))
--
Gary''s Student - gsnu200802

Finding the solution to an Exel problem.
 

MJohn wrote:
My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP'
functions and they return a value when certain criteria are met. There are
only 4 value scenarios that can occur. 1) Both cells have no response and a
'#N/A' is displayed in each cell. 2) Both cells have the same response,
(ie:'XT25' & 'XT25'). 3) The first cell has a response, (ie:'XT25') and the
second cell displays '#N/A'. 4) The first cell displays '#N/A' and the
second cell has a response, (ie:'XT25'). What I would like to do is simply
display any response other than '#N/A' only once in a third cell. In this
case, other than the 1st scenario ( both cells w/ '#N/A'), I would want
'XT25' displayed in the cell by itself (just 'XT25', not 'XT25,XT25' or
'XT25,#N/A'). I've exhausted my thoughts with 'IF', 'OR', and 'CONCATENATE'
functions and have failed. I keep getting 'Value' error responses. Is the
'#N/A' error the root of my problems when it is displayed. Even before a
condition occurs, '#N/A' is being displayed in the 2 adjacent cells. It
would seem like there would be an easy answer to this, is there?

MJohn,

Will this work for you?

=IF(ISNA(A1),IF(ISNA(B1),"",B1),A1)

What I'm not sure about is what you want to show if both cells have
values that are different. The above will default to A1.

Finding the solution to an Exel problem.
 

=IF(ISNA(first_cell),IF(ISNA(second_cell),"",secon d_cell),first_cell)


--
__________________________________
HTH

Bob

"MJohn" wrote in message
...
My scenario is as follows: I have 2 adjacent cells that have 'VLOOKUP'
functions and they return a value when certain criteria are met. There
are
only 4 value scenarios that can occur. 1) Both cells have no response and
a
'#N/A' is displayed in each cell. 2) Both cells have the same response,
(ie:'XT25' & 'XT25'). 3) The first cell has a response, (ie:'XT25') and
the
second cell displays '#N/A'. 4) The first cell displays '#N/A' and the
second cell has a response, (ie:'XT25'). What I would like to do is simply
display any response other than '#N/A' only once in a third cell. In this
case, other than the 1st scenario ( both cells w/ '#N/A'), I would want
'XT25' displayed in the cell by itself (just 'XT25', not 'XT25,XT25' or
'XT25,#N/A'). I've exhausted my thoughts with 'IF', 'OR', and
'CONCATENATE'
functions and have failed. I keep getting 'Value' error responses. Is
the
'#N/A' error the root of my problems when it is displayed. Even before a
condition occurs, '#N/A' is being displayed in the 2 adjacent cells. It
would seem like there would be an easy answer to this, is there?
--
Whoever has the correct answer, Thank You for knowing and caring.