firstly i would to thank you for your quick response , here i'm i want to apply condition in column B to match a value if it found matches then take the next opposite value in E and put it in another cell
I am afraid that doesn't clarify things for me to all. Your description is too generic.
Remember, while this issue is familiar to you, it is not for us. All that we know is what little have shared with us.
So be as detailed as possible.
So I will request again, please walk us through an actual example, referencing actual values and cell addresses.
Pick any value, and tell us what particular value should go in which particular cell?
Explain it, completely in detail, in English.
Maybe show us your expected output (you mention column F, but do not show it in your images).
here what i want exactly,
1- regular expression to extract the value in red if the value in Green found
2- make a search in B column with one of its values & if value found then copy the result of the regular expression next to the value to another cell
You did not mention that you require "regular expression" in your original question.
I do not use them, so I afraid I cannot be of help here (had I known that this was a requirement, I would have not replied).
Hopefully, someone else who knows them can.