matching words
 

i have data in column A of words i want to know if it is already with column
B, the problem is column A does not have the exact word and i used Vlookup
and it shows #NA value on column C.

help please.........

matching words
 

Please give us some examples of "does not have the exact word"
Also tell us what you VLOOKUP formula is.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"xander" wrote in message
...
i have data in column A of words i want to know if it is already with
column
B, the problem is column A does not have the exact word and i used Vlookup
and it shows #NA value on column C.

help please.........