Formula

Q

queenie

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

=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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing login email address for office 365 admin (O365 Busines) 0
New Outlook problem 0
Outlook - Catgorizing emails by names 0
Have 4 email addresses Want to auto forward all in one of them 0
Merging from an Excel file with graphics 1
Outlook 365 extremely stubborn 0
Blocking junk email 0
Autonumber field in Excel that behaves the same as Access 0

Top