When you need to search in a single row or column and find a value from the same point in a second row or column, use LOOKUP, one of the lookup and reference functions. Consider the following scenario: you know the component number for a car part but not the price.
The function of ADDRESS.
THE FUNCTION OF THE AREAS
UNIQUE PURPOSE.
SELECT A FUNCTION.
COLUMN PURPOSE.
COLUMNS ARE USEFUL.
INDEX PURPOSE.
The VLOOKUP function does a vertical lookup by searching the first column of a table for a value and returning it in the index number position in the same row. The VLOOKUP function is a Lookup/Reference Function that comes with Excel.
Select the data from cells A2 through C6 to designate the range for Vlookup. Then, in the Name Box, we may give the table range any name we want, as shown below. As illustrated below, modify the name to Sales Info. We'll use Vlookup in the second table once more, just like we did before.
Learner's Ratings
4
Overall Rating
56%
21%
6%
6%
11%
Reviews
N
Nitesh kumar gupta
5
nice course all the video explained very well from scratch to advance
S
Shubham Maurice
5
Overall Lectures are good but also provide the practicing spreadsheets for students.
S
Shivam Gautam
5
very good experience
K
KALAGA NARAYAN
5
i dont think some one can explain deeply ,practically rathere than this tutor
L
Lavkesh Kushwaha
5
West
K
Kamran Ahmed
5
Helpful course
S
sanjeet kumar
4
some excercise should be there. I have not studied standerd deviation of population in second module but question has been asked.
V
Vishisht
5
good
S
Shringa A G
5
This is a really helpful course for beginners as well as experts. You can develop your skills from this course.
Share a personalized message with your friends.