convert vlookup formula to link formula

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an if then scenario 2
I need a cell to be blank. 4
VLOOKUP & Data Validation 0
VLOOKUP 1
vlookup multiple data 11
VLOOKUP returning formula 3
Vlookup problem 3
Extract Formula to Text 6

Top