Function in excel 2013

[Solved/Closed]
Report
-
Posts
17203
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 28, 2021
-
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 reply

Posts
17203
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 28, 2021
5
Perhaps this?
=IF(A2="AB";A1;IF(A2="CD";A3;"?"))