ok dilip sir
i will wait for your and Steve reply
On 25/01/2010, Dilip Pandey <dilipan...@gmail.com> wrote:
> Dear Ankur,
> Index Match is gud approach if there are more than 3 locators (1a, 1b,
> 1c). I am not sure how Steve has the data setup n what is his further
> req. are. I think he has only one column of data set alongwith 3
> criterias.
> Steve, pls let d group know if u still need more enhancements.
> Ankur, right now i m mobile n not having Excel with me, so i will chk
> your solution after few hrs.
> Thx n regards,
> DILIpandey
>
> On 1/25/10, ankur <ankurpande...@gmail.com> wrote:
>> hi Dilip Sir & Steve
>>
>> if we have large data of similar basis, than we have to use different
>> value in IF Function ,it will be very time consuming, i tried a
>> approach please tell me is this is better or not
>>
>> =INDEX(A2:B4,MATCH("*"&D2&"*",A2:A4,0),2)
>>
>> plz check the attached file
>>
>> On 25/01/2010, Dilip Pandey <dilipan...@gmail.com> wrote:
>>> Dear Steve,
>>>
>>> Assuming every time the code will start with 1 and this may appear
>>> anywhere
>>> in the text, you can use below formulae in next two columns after your
>>> data,
>>> respectively.
>>>
>>> =MID(A2,SEARCH(1,A2),2) =IF(C2="1a","Tampa, Fla.",IF(C2="1b","St.
>>> Petersburg, Fla.","Dunedin, Fla."))
>>>
>>> Solved workbook is also attached with this email.
>>>
>>> Best Regards,
>>> --
>>> DILIP KUMAR PANDEY
>>> MBA-HR,B COM(Hons.),BCA
>>> Mobile: +91 9810929744
>>> dilipan...@gmail.com
>>> dilipan...@yahoo.com
>>> New Delhi - 110062
>>>
>>>
>>> On 1/25/10, Steve <mck1...@gmail.com> wrote:
>>>>
>>>>
>>>> A B
>>>>
>>>> 1 ILLINOIS vs. IOWA 1a
>>>> Tampa Fla.
>>>>
>>>> "1a" is a location code and is equal to Tampa Fla., Cell A1 contains
>>>> the two competing teams plus "1a". I want to search for "1a" in A1
>>>> and when it is found have excel return the location(Tampa Fla.) in a
>>>> new cell (B1).
>>>>
>>>> This problem seems very easy, but i am having trouble getting exactly
>>>> what i need.
>>>>
>>>> Thanks for the help,
>>>> Steve
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>> http://www.excelitems.com
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>> If you find any spam message in the group, please send an email to:
>>>> Ayush Jain @ jainayus...@gmail.com
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,700 subscribers worldwide and receive many nice notes
>>>> about
>>>> the learning and support from the group.Let friends and co-workers know
>>>> they
>>>> can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>
>>> --
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain @ jainayus...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,700 subscribers worldwide and receive many nice notes
>>> about
>>> the learning and support from the group.Let friends and co-workers know
>>> they
>>> can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>> --
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>> --
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
> Sent from my mobile device
>
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
