Finding if an entered value exist from a column and returning the address of the cell

Hey guys, I have a task that I need to complete, and I am struggling to find the right VBA code

What I want to do is to enter a value inside a cell ( E.g E5) , and that value should be compared with a column of the same workbook( E.g, A2:A250), if the value exist , a message box of some sort should appear to indicate the value is found. I was able to figure this out using the Countifs function on vba, but my problem start after this. Now I would require the cell address of of the column cell where the value existed, ( Eg if E5 matches with A15), I should be able to get a message box that my value was found in A15. Then, what I would have to do is to compare the dimensions in the adjacent columns of E5(inputted value) , which is F5 to ensure the dimensions entered is accurate to the dimension of the adjacent column found earlier which is B15 in this case( since it is next to A15). I need a code that does not involve for loop as it was requested the solution should not require repetitive pressing the macro button. Can someone help me out here? Thanks!!

Sounds like an INDEX/MATCH formula could do this for you.

Attach a sample Excel workbook, by following the instructions given in the yellow banner at the top of the screen.

Hope this helps.

Pete

try below although with a for loop but it is inside a worksheet change

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.