Vlookup Help!!
I am trying to create a column that reads from a cell with a long
string of text. For example: PPC: Intro to World Studies 2003 TRP Assembly. I've tried using if statements and vlookups to extract "TRP" from the sentence, I did this using: =if(isna(match("*TRP*",F2,0),"Medium","Other"). How can I create a fromula that allows me to use multiple conditions? For example, if the cell contains "Cat", "Dog", "Bird," = animal? Thanks |
Vlookup Help!!
=IF(ISNUMBER(SEARCH("*TRP*",F2)),"Medium","Other")
" wrote: I am trying to create a column that reads from a cell with a long string of text. For example: PPC: Intro to World Studies 2003 TRP Assembly. I've tried using if statements and vlookups to extract "TRP" from the sentence, I did this using: =if(isna(match("*TRP*",F2,0),"Medium","Other"). How can I create a fromula that allows me to use multiple conditions? For example, if the cell contains "Cat", "Dog", "Bird," = animal? Thanks |
Vlookup Help!!
One way:
=IF(SUM(COUNTIF(F2,{"*cat*","*dog*","*bird*"}))=0, "Medium","Other") or =IF(SUM(COUNTIF(F2,"*"&{"cat","dog","bird"}&"*"))= 0,"Medium","Other") wrote: I am trying to create a column that reads from a cell with a long string of text. For example: PPC: Intro to World Studies 2003 TRP Assembly. I've tried using if statements and vlookups to extract "TRP" from the sentence, I did this using: =if(isna(match("*TRP*",F2,0),"Medium","Other"). How can I create a fromula that allows me to use multiple conditions? For example, if the cell contains "Cat", "Dog", "Bird," = animal? Thanks -- Dave Peterson |
Vlookup Help!!
Thank you , thank you!
Cheers! Dave Peterson wrote: One way: =IF(SUM(COUNTIF(F2,{"*cat*","*dog*","*bird*"}))=0, "Medium","Other") or =IF(SUM(COUNTIF(F2,"*"&{"cat","dog","bird"}&"*"))= 0,"Medium","Other") wrote: I am trying to create a column that reads from a cell with a long string of text. For example: PPC: Intro to World Studies 2003 TRP Assembly. I've tried using if statements and vlookups to extract "TRP" from the sentence, I did this using: =if(isna(match("*TRP*",F2,0),"Medium","Other"). How can I create a fromula that allows me to use multiple conditions? For example, if the cell contains "Cat", "Dog", "Bird," = animal? Thanks -- Dave Peterson |
All times are GMT +1. The time now is 09:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com