However I can not copy and paste your formula and make it work in my spreadsheet. SO i am not sure what i am doing wrong. I have a spreadsheet I can send but not sure how to have it post on here as well.. if you can please get in touch with if you can help me out.



perlink to a cell in another worksheet using VLookup
I'm not sure if I'm understanding you correctly, but this may help. The attached file makes a link in column B based on the value in column A (in Sheet1). It will link to the same value on Sheet2. Because it looks at the filename in the forumla, you need to save it on your comp and open it from there.

This is the formula, though there may be an easier way to do it:
=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0),"Link"))

If the range you were searching in on Sheet2 started at A2 then you would have to add 1 (I've underlined it below)
=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0)+1,"Link"))

If it started on A10 you would have to add 9 etc etc.

Edit: I added a link that will take you to a place based on the value of the cell using the hyperlink function. You would have to edit the number value in 2 places in the formula in order for it to work. This probably isn't what you want but it may help in some way.
Attached Files Attached Files
File Type: xls link.xls‎ (13.5 KB, 155 views) Download