Nikhil Samuel
New Member
- Joined
- Jul 5, 2011
- Messages
- 1
I have two excel sheets in a workbook.
I have the reference table in one sheet.I need to find if a certain string exists in the cell (which has a sentence) and look up the value against that string in reference table and write it.
This is what I'm trying to do.sheet 1 is operation sheet.sheet 2 is reference sheet.
VLOOKUP(FIND{"compare","contrast","x",..},from the sheet 1 column 1),if string exists,the value against that string in sheet 2 column 2 written in sheet 2 column 2)
{"compare","contrast"} are all words in sheet 1 column 1
I want to compare if any of the strings in the sheet 2 column 1 match with the string(in the sentence or array of strings) in sheet 1 column 1.Then if they match,the value against the string in sheet 2 column 2 should be generated at sheet 1 column 2.
can you please guide me how to write a macro for it?
I have the reference table in one sheet.I need to find if a certain string exists in the cell (which has a sentence) and look up the value against that string in reference table and write it.
This is what I'm trying to do.sheet 1 is operation sheet.sheet 2 is reference sheet.
VLOOKUP(FIND{"compare","contrast","x",..},from the sheet 1 column 1),if string exists,the value against that string in sheet 2 column 2 written in sheet 2 column 2)
{"compare","contrast"} are all words in sheet 1 column 1
I want to compare if any of the strings in the sheet 2 column 1 match with the string(in the sentence or array of strings) in sheet 1 column 1.Then if they match,the value against the string in sheet 2 column 2 should be generated at sheet 1 column 2.
can you please guide me how to write a macro for it?
