Q queenie Jan 24, 2008 #1 need a formula if email address = same email address in diffreent column get the name (which is next to email address column)????
need a formula if email address = same email address in diffreent column get the name (which is next to email address column)????
G Gord Dibben Jan 24, 2008 #2 =IF(E1=OFFSET(E1,0,1),OFFSET(E1,0,1),"no match") Assuming columns are E and F E and H would be =IF(E1=OFFSET(E1,0,3),OFFSET(E1,0,3),"no match") Gord Dibben MS Excel MVP
=IF(E1=OFFSET(E1,0,1),OFFSET(E1,0,1),"no match") Assuming columns are E and F E and H would be =IF(E1=OFFSET(E1,0,3),OFFSET(E1,0,3),"no match") Gord Dibben MS Excel MVP
Q queenie Jan 24, 2008 #3 not sure i understand i have col a (email address ) column b (name) Column C differnet rows than col a & B need name from column B if C = True Does that make sense
not sure i understand i have col a (email address ) column b (name) Column C differnet rows than col a & B need name from column B if C = True Does that make sense
