hi, i have 1 workbook with 2 tabs - on Sheet 1 i need to hyperlink the column COLOR to Sheet 2 with vlookup function.
i've tried this but doesn't work. =HYPERLINK(VLOOKUP(B2,'SHEET 2'!A1:B3,2,0)
please help me with this. i will need to key in the formula in Sheet 1 B2, and when click on B2, it brings me to Sheet 2 A2, and in Sheet 1 B2, it will display as Sheet 2 A2 name.
Sheet1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
i've tried this but doesn't work. =HYPERLINK(VLOOKUP(B2,'SHEET 2'!A1:B3,2,0)
please help me with this. i will need to key in the formula in Sheet 1 B2, and when click on B2, it brings me to Sheet 2 A2, and in Sheet 1 B2, it will display as Sheet 2 A2 name.
Sheet1
A | B | |
1 | FRUIT | COLOR |
2 | APPLE | RED |
3 | LEMON | YELLOW |
<tbody>
</tbody>
Sheet 2
A | B | |
1 | COLOR | DETAILS |
2 | RED | SWEET |
3 | YELLOW | SOUR |
<tbody>
</tbody>