Register now or log in to join your professional community.
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.
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:-
Formula Explanation: =VLOOKUP(F3,$A$3:$D$13,2,0)
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