Big Project Request // search Value of specific cell " case sensitive " corresponding cell

Dear All,

Sorry to make it long , but it is challenging and bit long request , I have tried to many functions but with no result of what i want.

Issue description : I want to enter a " text" in a cell in a sheet let's call it control panel and click a button to :

- search for this Cell in specific 2 columns , and case sensitive and exact match
* if not found , return a msg box that the value is not true
- if found , return text value of corresponding cells ( more than value in more than cell )

let's see below image clarifying it

Untitled.png

the best I could do is below code in search button

Please Login or Register  to view this content.

but defiantly is not working the way i want ,, attached a file example to test on Search request.xlsx

thanks for your support

The code is already working but it is not giving me what i want , it is not issue of week43 senstive typing , what i want is not what i already write , i need something instead

what is the difference ? and still not giving me what i want

Could advice please ?

It seem logical however it shows an error in the searching lines , the code is not working probably , could u plz check for a fix ?

U r amazing . Thank u