Vertical Lookup is abbreviated as VLOOKUP. It's a function that tells Excel to look for a specific value in a column (the so-called'table array') in order to return a value from another column in the same row.
The following arguments are passed to the VLOOKUP function: Lookup value (mandatory parameter) – The value to search up in the first column of a table is specified by Lookup value. The table array is the data array to be searched (mandatory argument).
Choose a column of cells to populate with new information.
Select 'Function' (Fx) > VLOOKUP from the drop-down menu and paste the formula into the highlighted cell.
Type the lookup value for which you'd like to get fresh information.
Select the table array in the spreadsheet that contains the data you want.
Learner's Ratings
4.7
Overall Rating
82%
10%
4%
3%
1%
Reviews
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
S
Souvik Dutta
4
very good course
R
Raj
5
zero to hero course excel
K
KAUSHIK PAUL
5
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.
Share a personalized message with your friends.