Function in excel 2013 [Solved/Closed]

Report
-
Posts
15976
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
June 10, 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
15976
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
June 10, 2021
5
Perhaps this?
=IF(A2="AB";A1;IF(A2="CD";A3;"?"))

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!