If you are working on excel on huge data in you office, school or collage you must know the uses of VLookup. when we talk about data lookups, V lookup is a initial part of the same. Please go through the full article for your better understanding. Must watch the video also.
1. What is V lookup?
Ans. V lookup is a lookup function.
2. What are limitation of v lookup?
Ans. V lookup only match data left to right.
3. What we need for the Function?
Ans. 2 data sets with one unique column.
Here is the example of V lookup Function:-
1. If you are going to use v lookup you must have 2 data sets. as i mentioned below.
In above image you are able to see that we are looking for sales in data 2. So We have employee id in common so we can use vlookup here.
2. See the formula here:
0 comments:
Post a Comment