Team- this should be an easy one but I'm not seeing a solution online. I need to populate a cell based on text contained in the cell next to it.
So, if A1 has the text "TEACHER, GRADE 4", then I need the cell next to it to auto-fill with "Johnson Elementary" based on the "grade 4", so it's not an absolute value- it has to look for that text substring.
Thoughts?
Thanks in Advance- Scott
Hi Scott,
Based on your one input...
=IF(ISNUMBER(SEARCH("GRADE 4",A1)),"Johnson Elementary","")
HTH
Regards, Jeff
Or ...
=IF(COUNTIF(A1,"*GRADE 4*"),"Johnson Elementary","")
Thanks a ton Jeff- that worked. And thanks Phuocam as well.
If I may indulge your help one more time- now I have to modify this to cover any grade that might appear in the adjacent cell- so, if A1 has Grade 4 it would show Johnson Elementary, if A1 has GRADE 5 it must display Hoover Elementary, if Grade 6, MLK School, etc. There are a total of eight grades in adjacent cells with 5 corresponding schools...
Thanks in advance!
Maybe try a lookup table...
B1 =VLOOKUP(MID(A1,FIND(",",A1)+2,LEN(A1)),C1:D8,2,0)
Or if you wanted to embed the table...
Please Login or Register to view this content.
B1 =LOOKUP(MID(A1,FIND(",",A1)+2,LEN(A1)),{"Grade 4","Jan";"Grade 5","Feb";"Grade 6","Mar";"Grade 7","Apr";"Grade 8","May";"Grade 9","Jun";"Grade 10","Jul";"Grade 11","Aug"})
Of course just replace "Jan", "Feb" with your specific school names.
Thank you very much sir- I appreciate your help!
You are very welcome. Thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks