Return value base on data availability

[uday]

Hi,

I am trying to extract value based on data availability in Col A and Col B.
If the Col A value is matching with B or equal to Col B then should return any of them value in Col C and if the Value is not present in any of the col then should return the existed value from col A or B.

Please see the attached file for more information.

Thanks
Uday

 

[jayalaxmi]

Hi,

I am trying to extract value based on data availability in Col A and Col B.
If the Col A value is matching with B or equal to Col B then should return any of them value in Col C and if the Value is not present in any of the col then should return the existed value from col A or B.

Please see the attached file for more information.

Thanks
Uday

Hi Uday,

Try this:

=LOOKUP(2,1/(A2:B2<>""),A2:A2)

Regards
Jaya S

 

[bosco_yip]

Or,

=IF(B2<>"",B2,IF(A2<>"",A2,""))

Regards
Bosco