| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
need a formula if email address = same email address in diffreent column get
the name (which is next to email address column)???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
=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 On Thu, 24 Jan 2008 11:34:00 -0800, queenie wrote: need a formula if email address = same email address in diffreent column get the name (which is next to email address column)???? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
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 "Gord Dibben" wrote: =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 On Thu, 24 Jan 2008 11:34:00 -0800, queenie wrote: need a formula if email address = same email address in diffreent column get the name (which is next to email address column)???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
