A                            B                                      
    C
1 Walla Walla    =MATCH(A1&"*",Sheet1!A1:A1077,0)
                                                                         
=HYPERLINK("#sheet1!A"&B1,"GO TO")    

               
Obiouosly, my hyperlink in cell C1 sends me to ColumnA570, because cell B1
has 570 embossed in it...because Walla Walla appears in Sheet1, column A, row
570!

QUESTION:  HOW CAN I ALSO SEARCH  "Walla Walla" in Sheet 1 , column E as
well as in colum A (as is presently the case)?

I don't wish to use 2 MATCH and HYPERLINK functions -- but, I wish to
combine the 2 functions something like:

                  =MATCH(A1&"*", OR(Sheet1!A1:A1077,Sheet1!E1:E1077),0)

followed by;                  
                             
=HYPERLINK(OR(("#sheet1!A"&B1,"#sheet1!E"&B1),"GO TO")

Thamks:

FLKulchar

PS: My method, just described above does NOT work!!!!!!!!!!!!!!