Search more than 6 words and write by using Macros

**canada123** · 02-17-2010, 07:35 PM

Hi,
I will appreciate your expert help.
Attached is excel example.

I want to search say in column A for specific words say “Don” and then write in another column (say column 2) as “one”. Then it should keep searching for specific word until the last cell in that column and keep writing specific word in another column. It should do nothing if that specific word is not found.

I was able to use IF(ISERROR) but there is limitation of max 6 searches. Also i was able to achieve it by so many iteration of IF(ISERROR) and using autofilter.

My goal is to search around 30 to 40 criteria in one shot or by writing macros.
I guess i have presented my problem properly.

Thanks in advance.
Sanjay

**JBeaucaire** · 02-17-2010, 08:16 PM

Based on your example,I would switch to a VLookup table, like so...

**canada123** · 02-18-2010, 12:36 AM

JBeaucaire,

It is perfect and that's what i was looking for.

Thanks a lot,,You are genius for me.
Sanjay

**canada123** · 02-22-2010, 02:29 PM

This post has been deleted and moved to new thread.

**JBeaucaire** · 02-22-2010, 05:13 PM

Not sure, really. That is a completely different puzzle. If you close this thread (erase the post above) and start a new thread, you'll get the most attention from new contributors.

Be sure to EDIT your original post in this thread, click Go Advanced and mark the PREFIX box [SOLVED].