convert vlookup formula to link formula

  • Thread starter Thread starter AFA
  • Start date Start date
A

AFA

Scenario
Worksheet 1- Cell A1 to A6
Worksheet 2-Cell B1 to B2

At worksheet 2- Cell B2, i write Vlookup(+B1,Worksheet1 A1:A6,6,false) and a
result pop up at cell B2. Thus B2 formula "= Vlookup(+B1,Worksheet1
A1:A6,6,false)"

altenatively, i can just hit + and click at worksheet1-cell A6 and the
result will be the same as my look up file . If have more rows and
lookup,,,,,,

Question
Can i convert/display the formula to "=+A6" from "= Vlookup(+B1,Worksheet1
A1:A6,6,false)" without manually click at cell W1-A6?

Thanks & best regards
 
Back
Top