Hyperlink proble

[DougDR]

Hi again

WHY wont this work

Hyperlink("[StockListControl.xls]Sheet!"&"C"&Row(Vlookup(##,##,#,0))

 

[Ruddles]

What value does Row(Vlookup(##,##,#,0)) return at the point where it doesn't work?

 

[DougDR]

Just NA it wont even let me out of the formula editing mode

 

[Ruddles]

Can you post the actual formula you're entering rather than putting hashes in it?

I assume you're not actually entering Row(Vlookup(##,##,#,0))?

 

[DougDR]

<table style="width: 768px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col width="64"></colgroup><tbody><tr height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64">Hyperlink("[StockListControl.xls]SD!"&"C"&Row(Vlookup(E11,SalesPage,2,0)))</td> </tr></tbody></table>

Can you post the actual formula you're entering rather than putting hashes in it?

I assume you're not actually entering Row(Vlookup(##,##,#,0))?

 

[Ruddles]

Hmm...

What sort of thing does Vlookup(E11,SalesPage,2,0) return? Is it the row that E11 is found on in SalesPage? I mean, you're looking up the value of E11 in SalesPage and the VLOOKUP returns column 2 of the table, that's got the row number in it and the hyperlink points to column C and the row number where the value in E11 was found in SalesPage. Have I understood the situation correctly? (I may not have expressed it very well!)

If so, then you don't need the ROW bit of the formula:-

Hyperlink("[StockListControl.xls]SD!"&"C"&Vlookup(E11,SalesPage,2,0))

Give that a try?