How to get the vlookup value in hyperlink in excel sheet:
I have link column in sheet one which shows hyperlink column depend on drop down value .
When i click on relevant link link should go to sheet three and certain cell value:
File is attaechedAttachment 378133Attachment 378133
Like this?
in ONE!F1
=VLOOKUP(A1,LINK!A$1:B$5,2,0)
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi special-k thnaks for your help :
I solved it :using match in hyperlink
cheers
sample file is uploadedXXX.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks