Hi All,

Is there any trick to preserve direct reference in vlookup? here is my problem:

for example I have a table and inside that table I can find a value by:

1. linking the cell directly (e.g to A1)

2. OR do vlookup

but problem is by using vlookup I cant use ctrl+[ to directly trace back to A1 - is there any way we can do this by vlookup ya?