Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting a value
Hi, In cells A1 to A500 i have hyperlinks to other workbooks. In cells B1 to B500, i want to create a formula to get the value of the cell A4 of each hyperlink in the column A. Is this possible? -- serge ------------------------------------------------------------------------ serge's Profile: http://www.excelforum.com/member.php...fo&userid=4164 View this thread: http://www.excelforum.com/showthread...hreadid=543195 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting a value
You need to separate the issues...
The fact that you employ a hyperlink to jump you to another location (workbook, worksheet, or otherwise) is mutually exclusive from the fact that you want to obtain an explicit value from another location (workbook, worksheet, or otherwise) in the present cell location... You the "Index" function Syntax 1 to return the value of a specified cell from anoth location... in cell B1 use this formula: =INDEX([test.xls]Sheet1!$A$1:$B$5,4,1) Where [test.xls] is the name of the workbook Where Sheet1!$A$1:$B$5 in the location of the data in test.xls Where 4 is the row number containing the value that you want Where 1 is the column number containing the value that you want -- Thanks for your help - Joe Mac "serge" wrote: Hi, In cells A1 to A500 i have hyperlinks to other workbooks. In cells B1 to B500, i want to create a formula to get the value of the cell A4 of each hyperlink in the column A. Is this possible? -- serge ------------------------------------------------------------------------ serge's Profile: http://www.excelforum.com/member.php...fo&userid=4164 View this thread: http://www.excelforum.com/showthread...hreadid=543195 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|