Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-17 Thread Umed Singh
On 2/16/11, Aindril De aind...@gmail.com wrote: Hi Mike, Please use: =VLOOKUP(A2,Sheet1!B:B,1,0) instead. Regards, Andy On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike michael.lovel...@gmail.comwrote: I am struggling with this and wondering if you could help.. Worksheet 1 Column A B

$$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-15 Thread MikeMikeMike
I am struggling with this and wondering if you could help.. Worksheet 1 Column A B Keyword Category telecom Telecom tele com#N/A Worksheet 2 Column A B termcategory telecom Telecom telcom Telecom tele comTelecom What I want to do is pull the category name from worksheet 2

Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-15 Thread Aindril De
Hi Mike, Please use: =VLOOKUP(A2,Sheet1!B:B,1,0) instead. Regards, Andy On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike michael.lovel...@gmail.comwrote: I am struggling with this and wondering if you could help.. Worksheet 1 Column A B Keyword Category telecom Telecom tele com#N/A