JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER


Joined
Nov 12, 2019
Messages
3
Reaction score
1
HI THERE
IS THERE A WAY I CAN JUMP FROM THE SEARCH CELL TO THE RESULT OF THAT SPECIFIC SEARCH? ALL THE SEARCH CELL DOES IS HIGHLIGHT THE RESULT IN THE RANGE I HAVE NAMED AND FORMATTED(CONDITIONAL) FOR THIS.

FOR EXAMPLE:
NAMED RANGE = A2 TO C10 (DATA IN CELLS ARE NUMBERS 1 - 30)
SEARCH CELL = E1
IF I TYPE "17" IN TO SEARCH CELL(E1) AND PRESS ENTER, IT HIGHLIGHTS B7(17). INSTEAD OF DONG THIS I WANT IT TO JUMP FROM THE SEARCH BAR TO B7 WHEN I PRESS INTER. BASICALLY I WANT IT TO JUMP TO THE CELL THAT I SEARCH FOR NOT JUST HIGHLIGHT IT.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top