Prev: alter column ref
Next: how do i get rid of doubles from my database?
From: Jacob Skaria on 27 Apr 2010 05:46
Apply the below formula in Sheet2 cell E1

=IF(ISNA(MATCH(D1,Sheet1!D:D,0)),"No",
INDEX(Sheet1!C:C,MATCH(D1,Sheet1!D:D,0)))

--
Jacob (MVP - Excel)


"pol" wrote:

> Ok.
>
> I have two sheet.
>
> Sheet1
> Code Mapp
> C D
> 301003 301-006
> 301005 739-245
> 301006 753-229
> 301007 739-247
> 301008 739-249
> 301009 802-435
> 301010 736-111
>
> Sheet2
> column D
> 301-006
> 000-050
> 000-051
> 000-052
> 753-229
> 000-056
> 000-060
> 000-061
> 000-070
> 000-072
> 000-075
>
> Output
> Sheet2
> column D
>
> 301-006 301003
> 000-050 Not Exist
> 000-051 Not Exist
> 000-052 Not Exist
> 753-229 301006
> 000-056
> 000-060
> 000-061
> 000-070
> 000-072
> 000-075
>
> Please advice me to use the function
> IF(ISNA(MATCH(D2,Sheet1!D:D,0)),"Not",Sheet1!C2)
>
> "pol" wrote:
>
> > the column A1 has custom format 000-000 having the data like this
> > 123-456
> > 001-789
> > 313-245
> > 456-779
> > 084-321
> >
> > The column B1 has the following data
> > ABC123456
> > DSD001789
> > HGH084321
> > YYY343434
> >
> > like this 7500 record exist. I want to find column B1 value (numeric ) in
> > Column A1. So ABC123456,DSD001789, HGH084321 exist in A1 . How I can search
> > that numeric part in column A1. Pls help . Is there any function to give in
> > formula bar.
> > or Is it possible to write CTR+F, CTRL V to find automatcially in ceach
> > cell. Please advice
> >
> > With thanks
> > Pol
First  |  Prev  | 
Pages: 1 2
Prev: alter column ref
Next: how do i get rid of doubles from my database?