S sauk304 New member Local time Today, 11:16 Joined Aug 5, 2010 Messages 5 Oct 21, 2011 #1 Hi Excel Gurus, can u help me on this problem cells A1 = 1 cells B1 = 2 cell C1 = 3 Result 1 = 2 = ABC 1 = 3 = DEF How do i get ABC if 1(A1)=2(B1) ? do i need to create table for referring ?
Hi Excel Gurus, can u help me on this problem cells A1 = 1 cells B1 = 2 cell C1 = 3 Result 1 = 2 = ABC 1 = 3 = DEF How do i get ABC if 1(A1)=2(B1) ? do i need to create table for referring ?
NBVC Only trying to help Local time Today, 14:16 Joined Apr 25, 2008 Messages 317 Oct 21, 2011 #2 I am not sure I understand your request. Can you elaborate on it a bit? My assumption from what I read so far is you want something like: =IF(A1=B1,"ABC",IF(A1=C1,"DEF",""))
I am not sure I understand your request. Can you elaborate on it a bit? My assumption from what I read so far is you want something like: =IF(A1=B1,"ABC",IF(A1=C1,"DEF",""))
