Good morning I would need a help for a formula that checks if the string of column B is present in column E.
* if it exists, report the relative column code A.
In column I you find the desired result.
thank you
Good morning I would need a help for a formula that checks if the string of column B is present in column E.
* if it exists, report the relative column code A.
In column I you find the desired result.
thank you
In G1, copied down:
=IFERROR(LOOKUP(1000,SEARCH($B$1:$B$10,E1),$A$1:$A$10),"Not Found")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Try this:
=IFERROR(INDEX(A$1:A$10,MATCH(TRUE,ISNUMBER(SEARCH(B$1:B$10,E1)),0)),"not found") Ctrl Shift Enter
simply perfect
The 2 solutions work
Thank you
see you next time
Why did you "award" me some negative Rep???? it's not particularly important.... but.
NO, I figured I clicked on Add reputation
I do not know what came out.
If I can rectify how can I do?
Something must have happened that was not wanted by me.
Yet I did it other times to add reputation
let me know
Thank you
Odd. When I look at the rep... all of them have a small green rectangle at the left... except yours, which is red. So I guess it's negative... Oh well, never mind!!
I'm sorry I do not know why he gives you a small red rectangle at the left ...
My Rep was not negative
Indeed a big thank you deserve it and it is not the first time that you help me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks