wyte32
06-17-2014, 05:04 PM
Hello all,
So I'm learning VBA also along with VBScript - and I'll be honest I keep getting the two confused, so please forgive me.
What I'm trying to do is: I have two columns (A & B), I'm trying to determine if column A has similar values that column B contains. So for example:
Column A
Animal Involved
Column C
The duck swam in the pond
Bear
The bear ate the fish
Duck
The bear danced
Monkey
I'd like to, in the Animal Involved column, be able to come up with a formula that will tell me if one of the values from column C is present in column A, and if so, what is it?
Is this possible? I have a script that I came up with, but it is in vbscript (sorry!) - after working with it for a while, I thought this might be easier in VBA and just call it as a macro. I've tried using =IF(MATCH(C2,A:A),"Animal Found","Animal Not Found"), but that didn't give me quite what I was looking for. Any suggestions?
So I'm learning VBA also along with VBScript - and I'll be honest I keep getting the two confused, so please forgive me.
What I'm trying to do is: I have two columns (A & B), I'm trying to determine if column A has similar values that column B contains. So for example:
Column A
Animal Involved
Column C
The duck swam in the pond
Bear
The bear ate the fish
Duck
The bear danced
Monkey
I'd like to, in the Animal Involved column, be able to come up with a formula that will tell me if one of the values from column C is present in column A, and if so, what is it?
Is this possible? I have a script that I came up with, but it is in vbscript (sorry!) - after working with it for a while, I thought this might be easier in VBA and just call it as a macro. I've tried using =IF(MATCH(C2,A:A),"Animal Found","Animal Not Found"), but that didn't give me quite what I was looking for. Any suggestions?