Namratashadangi
New Member
- Joined
- Jan 25, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I want to create a hyperlink in sheet1 which will point to corresponding row in sheet2 based upon below condition.
1. If A2 of sheet1=ST then lookup B2 of sheet1 to A column of sheet2 and w1 of sheet1 to C column of sheet2.if match found create hyperlink to the corresponding row in sheet2.
1. If A2 of sheet1=ST then lookup B2 of sheet1 to A column of sheet2 and w1 of sheet1 to C column of sheet2.if match found create hyperlink to the corresponding row in sheet2.