I am trying to figure out how to link a cell to a list on another worksheet. What I would like to do is have a function that searches an array of cells against a fixed cell and return a link to a list on another page that matches the fixed cell. For example, this is what I would like to do.

On Sheet1 all of the columns are shown as lists.

Sheet1....|....Col A..........|....Col B....|.....Col C....|
Row 1.....|....PO#............|....Item#..|......QTY....|
Row 2.....|....LL-16-1.......|........1......|......10.......|
Row 3.....|....LL-16-1.......|........2......|......15.......|
Row 4.....|....LL-16-1.......|........3......|......20.......|
Row 5.....|....LL-16-2.......|........1......|......11.......|
Row 6.....|....LL-16-2.......|........2......|......21.......|

Sheet2...|....Col A.............|.....Col B..........|....Col C....|....Col D...|
Row 1.....|....Link Function..|.....PO#...........|....Item#...|.....QTY...|
Row 2.....|....A2 Function....|.....LL-16-1......|.......1........|......10.....|
Row 3.....|....A3 Function....|.....LL-16-1......|.......2........|......15.....|
Row 4.....|....A4 Function....|.....LL-16-1......|.......3........|......20.....|
Row 5.....|....A5 Function....|.....LL-16-2......|.......1........|......11.....|
Row 6.....|....A6 Function....|.....LL-16-2......|.......2........|......21.....|

For example I would like the A2 function to work like this. If Sheet2!B2 = Sheet1!A2:A6 then provide a link in Sheet2!A2 that directs you to Sheet1 and only displays the rows where the PO#’s in Sheet1 A2:A6 match B2 on Sheet2 which in this case would link to rows 2, 3, & 4 on Sheet1. Like I said this is only an example and in reality I have about 2000 rows with entries. I do not know if there is even a way to do this but if anyone has any suggestions I would really appreciate it. Thanks.