finding matching text in different sheet

  • Thread starter Thread starter Brian Shafer
  • Start date Start date
B

Brian Shafer

I am using excel 2007.
I have to sheets... the column A on both sheets is filled with text. I
want to loop throught each cell on sheet one.. and find the text on sheet2
and highlight or something. Last time I made it a hyperlink on sheet one and
it would take me to sheet 2 if the value was there.... but I lost that
function and am struggleing to figure this out again.
Any help would be great.
Thanks, Brian
 
In sheet1 cell B1 apply the below formula and copy down as required....

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"",HYPERLINK("#Sheet2!A" &
MATCH(A1,Sheet2!A:A,0),"Go"))
 

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

Similar Threads

Progressive number in different sheets 7
Run two macros for two different sheets 11
Change event code Find .Activate does not activate Target.value 4
Create if partial match then copy and paste data from one cell to another 1
Macro to match 2 column values in different sheets 1
sheet event wait for another event? 6
Hyperlink to Same sheet but after that want to hide link sheet 1
Compating all rows in two sheets 2

Back
Top