Function in excel 2013

Solved/Closed
Saber Elajam - 24 Dec 2016 à 01:59
yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 - 24 Dec 2016 à 06:02
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


Related:

1 response

yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 5
24 Dec 2016 à 06:02
Perhaps this?
=IF(A2="AB";A1;IF(A2="CD";A3;"?"))