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

Analysing Big Data with Twitter Sentiments using Spark Streaming

In this big data spark project, we will do Twitter sentiment analysis using spark streaming on the incoming streaming data.

Web Server Log Processing using Hadoop

In this hadoop project, you will be using a sample application log file from an application server to a demonstrated scaled-down server log processing pipeline.

Walmart Sales Forecasting Data Science Project

Data Science Project in R-Predict the sales for each department using historical markdown data from the Walmart dataset containing data of 45 Walmart stores.

Spark Project -Real-time data collection and Spark Streaming Aggregation

In this big data project, we will embark on real-time data collection and aggregation from a simulated real-time system using Spark Streaming.

Predict Census Income using Deep Learning Models

In this project, we are going to work on Deep Learning using H2O to predict Census income.

Airline Dataset Analysis using Hadoop, Hive, Pig and Impala

Hadoop Project- Perform basic big data analysis on airline dataset using big data tools -Pig, Hive and Impala.

Hadoop Project-Analysis of Yelp Dataset using Hadoop Hive

The goal of this hadoop project is to apply some data engineering principles to Yelp Dataset in the areas of processing, storage, and retrieval.

Forecast Inventory demand using historical sales data in R

In this machine learning project, you will develop a machine learning model to accurately forecast inventory demand based on historical sales data.

Yelp Data Processing using Spark and Hive Part 2

In this spark project, we will continue building the data warehouse from the previous project Yelp Data Processing Using Spark And Hive Part 1 and will do further data processing to develop diverse data products.

Music Recommendation System Project using Python and R

Machine Learning Project - Work with KKBOX's Music Recommendation System dataset to build the best music recommendation engine.

Learn how you can build Big Data Projects