I have a multi-worksheet workbook... I want to be able to get from one worksheet in that workbook to another SPECIFIC location in a different worksheet. I am currently using HYPERLINK to do this but I can't figure out how to get to a specific place short of what I am doing... Here is the formula that I use... The value in B11 is a numeric... and as you can see I simply multiply that number times 4 and then subtract 4 to get me to a specific column... unfortunately that just doesnt' work... What I really want to do is look for the value in B11 in Row 4 of the Miles Worksheet and go to the first cell with that value.
=IF(B11="","",HYPERLINK(CONCATENATE("[Time2008.xls]Miles!",ADDRESS(3,B11*4-4,2)),"‼"))
For Example...
I am on Sheet1 in cell G11... From that Cell I need to Hyperlink to my Miles Worksheet, The Hyperlink would look for the Value that is found in Sheet1!B11 on Row 4 of the Miles Worksheet and position my cursor on Miles AB3 (if that is where it found the value from Sheet1!B11)
It is almost like I want to do an HLOOKUP in ROW4 of Miles and return the value of the cell when it finds it.... then I want to use my Hyperlink formula to go to that cell.
Anyone????
Bookmarks