Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT -- search in string for a value in another column, if found, return value from next column
Hello ALL!
Need an urgent help on this! I am not an excel pro, however can do a bit of troubleshooting if being helped. I have 2 different worksheets..# 1 and # 2...I want to search each cell from column A, worksheet#1 and see if it has any value from column A, worksheet#2. Each cell in Column A, worksheet#1 has strings and not one word values. So basically I want to search these strings to see if those have any word that is also in column A, worksheet # 2. If it finds one, then returns respective value form column B, worksheet #2 to respective column B, worksheet # 1..I used this code on B1 cell, however to make it worked, column A-worksheet#1 has to have single word values and not strings I believe: =IF(ISNA(VLOOKUP(A1,'worksheet2'!A:B,2,FALSE)),"No t Found",VLOOKUP(A1,'worksheet2'!A:B,2,FALSE)) Please correct me if I am going in different path...Again, I am not an Excel PRO but need to make this worked...Any help is appreciated.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT -- search in string for a value in another column, if found, return value from next column
=IF(ISNA(VLOOKUP("*"&A1&"*",'worksheet2'!A:B,2,FAL SE)),"Not
Found",VLOOKUP("*"&A1&"*",'worksheet2'!A:B,2,FALSE )) seems to work. -- Regards, Tom Ogilvy "samkshah" wrote in message oups.com... Hello ALL! Need an urgent help on this! I am not an excel pro, however can do a bit of troubleshooting if being helped. I have 2 different worksheets..# 1 and # 2...I want to search each cell from column A, worksheet#1 and see if it has any value from column A, worksheet#2. Each cell in Column A, worksheet#1 has strings and not one word values. So basically I want to search these strings to see if those have any word that is also in column A, worksheet # 2. If it finds one, then returns respective value form column B, worksheet #2 to respective column B, worksheet # 1..I used this code on B1 cell, however to make it worked, column A-worksheet#1 has to have single word values and not strings I believe: =IF(ISNA(VLOOKUP(A1,'worksheet2'!A:B,2,FALSE)),"No t Found",VLOOKUP(A1,'worksheet2'!A:B,2,FALSE)) Please correct me if I am going in different path...Again, I am not an Excel PRO but need to make this worked...Any help is appreciated.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT -- search in string for a value in another column, if found, return value from next column
Thank you very much Tom for prompt reply. I wonder if I am doing it
wrong or was unable to explain my problem correctly. I changed the code as you mentioned, however it still doesn't work...Let me explain my problem again: worksheet1: ColumnA I want to search this string and see if it has any word that belongs to columnA in worksheet2 Worksheet2: ColumnA ColumnB search return word this manager value temp in template other other worksheet As we see, word "Search" in column A, worksheet2 is in the given string in worksheet1...so I need word "return" from column B of worksheet2 in column B of worksheet1...if columnA, worksheet2 doesn't have any of the words from that string, then return "not found" Please let me know if you need more information. Again I appreciate your prompt response. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT -- search in string for a value in another column, if found, return value from next column
I doubt there is a simple formula that will work for that. You would first
need to parse out all the individual words in the string and then search the second sheet. -- Regards, Tom Ogilvy "samkshah" wrote in message oups.com... Thank you very much Tom for prompt reply. I wonder if I am doing it wrong or was unable to explain my problem correctly. I changed the code as you mentioned, however it still doesn't work...Let me explain my problem again: worksheet1: ColumnA I want to search this string and see if it has any word that belongs to columnA in worksheet2 Worksheet2: ColumnA ColumnB search return word this manager value temp in template other other worksheet As we see, word "Search" in column A, worksheet2 is in the given string in worksheet1...so I need word "return" from column B of worksheet2 in column B of worksheet1...if columnA, worksheet2 doesn't have any of the words from that string, then return "not found" Please let me know if you need more information. Again I appreciate your prompt response. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT -- search in string for a value in another column, if found, return value from next column
Tom:
Many thanks. I will do that way and will get back to you if I have any other problems. Regards ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return text value found most frequently in a column | Excel Worksheet Functions | |||
Search a column for values, return a value from adj column | Excel Worksheet Functions | |||
Formula to search for given term, and if not found in column to add it to list | Excel Worksheet Functions | |||
URGENT: Search for text in column and count by month | Excel Discussion (Misc queries) | |||
Search column - return row found in long text string | Excel Programming |