Victor... Great video.. not only your content is great but also your video production... Great tips on the Hyperlink function and that shortcut ALT left arrow to go back to your original cell. Thanks for posting!
@@ExcelMoments =IFERROR(HYPERLINK("#"&CELL("address",XLOOKUP([@[Line Description]],INDIRECT([@[Planning Tab]]&"[Line Description]"),INDIRECT([@[Planning Tab]]&"[CTC x GST]"))),"Go to"),"") It is in a change tracking register for multiple tables, takes a user directly to the client cost.
Great video and method! Thank you for creating/sharing this Victor! I use this trick all the time but I have not done a video on it yet so I am going to share yours and include a link to it when I discuss my use case in my video.
@@ExcelMoments I have that one saved to a playlist because it was so awesome and that when I started using it. I might be the only Excel person who hears "Address" and immediately thinks of the stargate movie/tv series but when I use R1C1 style as spacial coordinates it really helps as a mental visual.
it would look something like this =HYPERLINK("#"&CELL("Address",INDEX(Table1[Amount ($)],XMATCH(MAX(Table1[Amount ($)]),Table1[Amount ($)]))),"Max Value")
Victor... Great video.. not only your content is great but also your video production... Great tips on the Hyperlink function and that shortcut ALT left arrow to go back to your original cell. Thanks for posting!
Thanks Luis for the feedback. You know i love hyperlinks 😂
Interesting method Victor. Thanks for being so creative.
Thanks for the kind words
Nice little trick Victor, thanks for sharing
Very nice...I am goint ro use this😊
Couldn't wait to use it. That's a fun one. Nice 1 Victor.
So you already used it then?
@@ExcelMoments =IFERROR(HYPERLINK("#"&CELL("address",XLOOKUP([@[Line Description]],INDIRECT([@[Planning Tab]]&"[Line Description]"),INDIRECT([@[Planning Tab]]&"[CTC x GST]"))),"Go to"),"")
It is in a change tracking register for multiple tables, takes a user directly to the client cost.
It's cool - combined with the Alt left arrow so fast to copy and paste original amount before the change.
CELL function didn't cross my mind. I have always used ADDRESS with ROW and COLUMN functions to get it. Awesome 👍
As with most things Excel,always more than 1 way to do things!
Very cool 😊 Thanks Victor!
You are welcome. Glad you like it
Great video and method! Thank you for creating/sharing this Victor!
I use this trick all the time but I have not done a video on it yet so I am going to share yours and include a link to it when I discuss my use case in my video.
That would be great. I shared it back in 2021 at the London Excel Meetup, just thought to share it as a standalone
@@ExcelMoments I have that one saved to a playlist because it was so awesome and that when I started using it.
I might be the only Excel person who hears "Address" and immediately thinks of the stargate movie/tv series but when I use R1C1 style as spacial coordinates it really helps as a mental visual.
mind-blowing Victor! woah! --- 👉🤯
Great one
Thanks
Nice trick!
Thanks Dim. Next to yours, it is like child's play! 😀
How do you do it using Index function?
it would look something like this
=HYPERLINK("#"&CELL("Address",INDEX(Table1[Amount ($)],XMATCH(MAX(Table1[Amount ($)]),Table1[Amount ($)]))),"Max Value")
@@ExcelMoments thank you sir. I will try this.