Here is what i exactly need to do.
I have an excel workbook with many sheets. I need to work on two sheets- Attributes_Master and Domain_Details.
Both have a field in commmon - Domain but not in same order.
I need to add a hyperlink in Domain column of Attributes_master to Domain column of Domain_master. There are around 50,000 entries in that column.
I know that I can get to know the cell address in domain_master by using
MATCH() function. Any shortcut to get the hyperlink done quickly?
Best How To :
The Excel Hyperlink() function takes string arguments. You can build the string arguments by concatenating different elements.
A concrete formula is a bit hard without knowing your workbook structure.
Assuming that you want to link to the cell on the Domain_master sheet, and assuming that the column "Domain" is in column A on both sheets, try something along the lines of
Adjust to reflect your workbook file name and column structure.