y, September 07, 2011 9:04 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ code for search
>
> not working. and where to put this code. I made it on userform not on
> sheet. So in your formula there is no representation of the objects na. how
> it works ?
&
I’m one of those people who doesn’t much care for pivot tables and userforms.
KISS (Keep it simple, stupid). Not meant personally.
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ code for search
not working. and
,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
>
> *From:* Shankar Bheema
> *Sent:* Wednesday, September 07, 2011 8:14 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ code for search
>
> Hai all good evening
>
> I am attaching the excel sheet whic
How about a formula
=INDEX(A:B,IF(ISNA(MATCH(E4,B:B,0)),MATCH(E4,A:A,0),MATCH(E4,B:B,0)),IF(NOT(ISNUMBER(E4)),1,2))
From: Shankar Bheema
Sent: Wednesday, September 07, 2011 8:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ code for search
Hai all good evening
I am
Hai all good evening
I am attaching the excel sheet which contains file numbers and names in
corresponding file number. I placed an userform with file no. and name with
a command button for search.
If we know the name and dont know the file no. by giving little part of the
name and if pressed on
