H
HWDFWXCLGuru
I've wondered for QUITE some time whether there is a way an (adjacent cell)
formula result could declare: "Click Here to GoTo!", whether within that
table or even to another sheet in or workbook on network, et al.
I have AutoFilter applied to a Table where lookup value is not Table's first
column. Entering Job# to lookup in a secondary table (nee, internal range
defined) (Vlookup(value,range,col,false)) returns project name, desired
result. Seeking ability to GoTo that line of data.
Value entered in A1
A1 B1 C1
26947 (Vlookup(A1,RANGE,COL,FALSE) (bibbidy-bobbidy-boo!?!)
Job# Returns Job Name "Click Here to GoTo!"
Assistance in defusing/resolving this contemplation is earnestly sought!
formula result could declare: "Click Here to GoTo!", whether within that
table or even to another sheet in or workbook on network, et al.
I have AutoFilter applied to a Table where lookup value is not Table's first
column. Entering Job# to lookup in a secondary table (nee, internal range
defined) (Vlookup(value,range,col,false)) returns project name, desired
result. Seeking ability to GoTo that line of data.
Value entered in A1
A1 B1 C1
26947 (Vlookup(A1,RANGE,COL,FALSE) (bibbidy-bobbidy-boo!?!)
Job# Returns Job Name "Click Here to GoTo!"
Assistance in defusing/resolving this contemplation is earnestly sought!