Function in excel 2013

Solved/Closed

Saber Elajam - Dec 24, 2016 at 01:59 AM
yg_be Posts 24281 Status Contributor - Dec 24, 2016 at 06:02 AM

Hello Dear All.
who I can do this function in excel 2013

If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value

1 response

Answer 1 / 1

yg_be Posts 24281 Status Contributor 5
Dec 24, 2016 at 06:02 AM

Perhaps this?

=IF(A2="AB";A1;IF(A2="CD";A3;"?"))