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
