Prev: VLookup with Search for in String
Next: Calculate Number of Days worked in Each Month by Project
From: Zuo on 23 Mar 2010 22:25
Perfect! Thanks a lot Max.

"Max" wrote:

> > ... Not the cell location but the actual data ..
> It's even simpler then ..
> In E1, copied down: =IF(ISNA(MATCH(D1,A:A,0)),"",D1)
> Success? hit the YES below
> --
> Max
> Singapore
> ---
> > "Zuo" wrote:
> > >
> > > Almost there but I want the actual matching reference that is sitting in A1
> > > to appear in E4 next to its match on D4. Not the cell location but the
> > > actual data. i.e. if A1=23 and D4 =23 then 23 should appear in E4 or next to
> > > D4.
> > >
> > > Thanks.
>
First  |  Prev  | 
Pages: 1 2
Prev: VLookup with Search for in String
Next: Calculate Number of Days worked in Each Month by Project