| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Link to Specific List on Another Worksheet
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#...|.....Q TY...| 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. -- jdurrmsu ------------------------------------------------------------------------ jdurrmsu's Profile: http://www.excelforum.com/member.php...o&userid=27122 View this thread: http://www.excelforum.com/showthread...hreadid=508172 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a Formula which contains a link to another worksheet | Excel Discussion (Misc queries) | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| how to reference external refereces from a list | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
