The sample file has two sheets in it. "Entry" and the "Storage"
In entry sheet, there are data on column A and B.
Column A is control no. which will serve as the lookup value but with some conditions that must be met on Column B (Status)
The find macro or function will be triggered when clicking on any cell in column B at sheet entry"
If I click the B3 on sheet entry, then it will search the value of Cell A3 at Sheet Storage row 2:2. ONLY if the value of B3 is equal to "Vaulted". So it will take me to sheet storage directly to where is the control number is located (cell G2)
If cell B3 is not "Vaulted" then a pop up msg will say "Not Vaulted".
I hope it is possible and someone can help me in this.