| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert vlookup formula to link formula
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? | Excel Discussion (Misc queries) | |||
| How to convert a static formula to dynamic formula ? | Excel Worksheet Functions | |||
| Excell convert formula row to formula column | Excel Worksheet Functions | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
Hybrid Mode
