Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink Match
I am trying to match two columns and provide a link in the third column.
Data in Worksheet1 Column H I J Description Sub Amount Product 1 100 25000 Product 2 200 40000 Worksheet2 Description Sub Details Product 1 100 stuff Product 1 200 stuff Product 1 100 more stuff Product 2 200 stuff Product 2 100 more stuff In Column G in Sheet1, I have this formula, HYPERLINK("#'Sheet2'!A" & IF (MATCH(H12,Sheet2!$A$1:$A$29,0)=MATCH(I12, Sheet2!$A$1:$A$29,0),MATCH(H12,Sheet2!$A$1:$A$29,0 ),0), "Link") The formula will work only if the first row of data is correct. Could someone help me fine tune this please? Thanks, Corrine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
search column, hyperlink, offset, substitute, match (omg) | Excel Discussion (Misc queries) | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |