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

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.

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

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

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

Agreed Vlookup and Hlookup tools are the best.

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

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

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

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. 

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

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.

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

Ghada Eweda's answer