Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is Microsoft Excel's tool used to find the data in the large spreadsheet and how to use it?

user-image
Question added by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.
Date Posted: 2016/04/12
Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

Vlookup Excel Tool 

Vlookup is used to find the data in the large spreadsheet by lookup value in another worksheet. To use the Vlookup function, we should have common values in both data. For example, we want to search the phone number of a person. So, in order to find out the phone number, we will need the concerned person’s name.

How do we use it

We have 2 set of HR data in Excel. In the second data, we want to update joining date of every employee from the first data. To use the Vlookup function, data must have the common value.

image 18

 

Follow below steps:-

  • Enter the formula in cell G3
  • =VLOOKUP(F3,$A$3:$D$13,2,0)
  • Press enter and copy the same formula in the range F4:F13

image 19

 

Formula Explanation: =VLOOKUP(F3,$A$3:$D$13,2,0)

  • In this formula, F3 is the cell of common value or lookup value
  • Then we have selected the range $A$3:$D$13 to the 1st data
  • 2: we have defined to pick the value from the 2nd column
  • 0: we have defined for the exact match

danish shafiq
by danish shafiq , Accountant , Anayat Fan

Simple and best one is to use "Find tool" using "Ctrl + F" .

Shazia Anees
by Shazia Anees , Assistant Manager Finance , Arham Trading Company

Agreed Vlookup and Hlookup tools are the best.

Rey Jay-r Calalang
by Rey Jay-r Calalang , Accounting/Administrative Officer , Ric's Kountry Kitchen

use the Ctrl+F or find button usually that is the fastest way to find specific data in excel sheets. 

if it is numbers type the actual numbers it will show you everything

Esraa Ahmed
by Esraa Ahmed , Senior Office Administrator/Office Supervisor , Altakamul International School

Select al used Ctrl+A then Used Ctrl+F to find any information we need

HASSAN AHMED
by HASSAN AHMED , Internal Auditor , TIE

Thanks for the invitation, There are many methods to find data, I will tell 4 methods,

1) Select all (ctrl +A) and then press ctrl + F and type what you want to search

2) Apply filters on all columns and search in required column

3) Vlookup or vertical lookup to search data in Column

4)hlookup or horizontal lookup to search data in Row

Entisar Al Faisal
by Entisar Al Faisal , project construction engineer , City of Dearborn

use the Ctrl+F or find the button to find specific data in excel sheets. 

Abid Ali
by Abid Ali , Accountant , STC

find the data in the large spreadsheet by using Vlookup and the formula  - =Vlookup("Search specific data name", A1:B1000 depending on spreadsheet columns and rows. 

Yahia mohamed  Amen Gad
by Yahia mohamed Amen Gad , إدارة - مدرب - , سنابل الأجيال للتعليم والتدريب

Thank you for your kind invitation and I agree with the answer Professor Fateh Abdulmajeed Almokad and Dr. Ghada

Tamer Elbeshbishy
by Tamer Elbeshbishy , Financial and Administration Manager , Muscat Towers Holding Group

The answer of Mrs Ghada is perfect, we are using this function  always on our recording and reporting.

Vlookup is used to find and link and manage data. While Ctr+F "Find"  is being used to find only.

Abdul Kareem Chala Mohammed
by Abdul Kareem Chala Mohammed , Senior Designer , iSmarthome

Thank you for invitation,. I agree with Ms. Ghada Eweda

Ghada Eweda's answer

More Questions Like This