Re: $$Excel-Macros$$ Help with INSTR

2012-12-19 Thread Matt
Hi Anoop, That code was really helpful. I modified it to help do what I was trying to do. The only problem I have now is that It only seems to apply the type to the first match it finds and disregards the rest of them. Any Idea how I would be able to apply the code to the rest of the rows? H

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Matt
Hi, i put the link at the bottom of. my question. tx here is the link with the spreadsheet https://www.box.com/s/33z5kuabqbjn2b971ae6 matt -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Matt
Hi, i put the link at the bottom of my question. tx matt -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

Re: $$Excel-Macros$$ Help with INSTR

2012-12-17 Thread Anoop K Sharma
Matt, Please share your workbook. Regards, Anoop Sr. Developer On Sat, Dec 15, 2012 at 9:58 PM, Matt wrote: > Hi, search the forum but couldn't find an example that fit. I'm trying to > do a search off column "A" on the "Lookup" tab, and search for it in the > yellow column in the "2010Chase"

$$Excel-Macros$$ Help with INSTR

2012-12-15 Thread Matt
Hi, search the forum but couldn't find an example that fit. I'm trying to do a search off column "A" on the "Lookup" tab, and search for it in the yellow column in the "2010Chase" tab using the "Instr" function and return a value but can't seem to get the code to work unless the words are iden