for Vloop up function how to lock value in table_array parameter using keyboard shortcut?

chetan

What is the keyboard short cut to lock the table_array parameter in the Vlookup function.
e.g. table_array parameter is range B2:E15, how do i make it $B$2:$E$15 using the keyboard shortcut?

Dec 29 2013 08:40 PM

2 Answer(s)

Binny

f4.

place your cursor inbetwwen the "B' and "2" and press F4. it will lock it.

Dec 31 2013 03:52 PM

Supriya

Place your cursor in betwwen the "B' and "2", "E" and "15" and hit F4

Feb 09 2015 09:52 AM

Relevant Projects

Real-Time Log Processing using Spark Streaming Architecture

In this Spark project, we are going to bring processing to the speed layer of the lambda architecture which opens up capabilities to monitor application real time performance, measure real time comfort with applications and real time alert in case of security

Tough engineering choices with large datasets in Hive Part - 2

This is in continuation of the previous Hive project "Tough engineering choices with large datasets in Hive Part - 1", where we will work on processing big data sets using Hive.

Solving Multiple Classification use cases Using H2O

In this project, we are going to talk about H2O and functionality in terms of building Machine Learning models.

Spark Project-Analysis and Visualization on Yelp Dataset

The goal of this Spark project is to analyze business reviews from Yelp dataset and ingest the final output of data processing in Elastic Search.Also, use the visualisation tool in the ELK stack to visualize various kinds of ad-hoc reports from the data.