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
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