Skip to main content


Welcome to Daily Updates

*** Happy Learning***
==>Daily Job Updates IT and Non IT

==>Every month Current Affairs

==>Every month Dividend, Bonus Issue and Stock Split information

==> JAVASCRIPT QUIZ

==>AADHAAR download, Date of birth,name and Address correction, PVC card and more links

==> MICROSOFT EXCEL TUTORIAL

Advance Excel Concepts - VLOOKUP

 Advance Excel Concepts - VLOOKUP

VLOOKUP is one of the Advance Excel Concepts. VLOOKUP is Vertical Lookup. VLOOKUP helps to find the the respective column details of the particular data in the table 


Formula Syntax: 
                                    =VLOOKUP(Value have to lookup, Table array , Column index, Match indication(Optional))

=> Value have to lookup means need to provide the value that wants to search for
=> Table Array means the Table where we want extract the data this table needs to select
=> Column Index means the column where the value respective lookup value to extract 
=> Approximation match - True(1) or Exact Match - False(0) 

Illustrations -

Steps that we need to follow to be successful in VLOOKUP 

1. Initially, Have the table ready like as below 


2. After that you have to take some column names that wants to extract from table
VLOOKUP_Excel_2

3. And then have the Student_ID in the below Student_ID
VLOOKUP_Excel_3
4. In next step, We can write the Formula for VLOOKUP for our requirement, Once formula has written then just give ENTER

                                              =VLOOKUP(B19,A1:G13,2,0)
 => B19 - Lookup Value
=> A1:G13 - Table Array
=> 2 - Column Index
=> 0 - Match Indication(Optional)





5. Finally, Drag it to left side in our case you will see the Student_Maths_Marks data for this student_ID


That's it all about VLOOKUP process. Successfully Learned VLOOKUP, Now searching in huge data and extracting data in enormous data Table can be done easily.

 
                                ** Comment below for any clarifications, Happy to answer **


Labels:

Comments

Post a Comment

Popular posts from this blog

JNTUK Convocation VIII for 2018-19 and 2019-20 batch OD apply

JNTUK Convocation VIII for 2018-19 and 2019-20 batch, who have taken the PC in the period of 01/01/2019 to 31/12/2020 For more details Click here last Date to apply - 18-12-2021 Required Documents: 1. PC 2. CMM (For UG ) 3. SSC 4. Recent Photo  5. For PG courses - Sem wise mark sheets 6. Adhaar front and back scanned copy 7. Bank challan or Payment - Those made offline payment should submit hard copies of above documents at the university examination Fee - Rs.2000/- Process to apply: 1. Register with Hall ticket number and email Id(user name) - Click here 2. Login with user name(E-mail ID) and password - click here 3. Enter the details and next step will be payment  Note: Updation of payment status into complete status may take 2-3 days 4. Then need to attach the required documents 5. Next step is to check the details and everything and then click on check box by agreeing that there information was furnished by you is true. 6. There will be no Submit option that is only downlo...
Post a Comment
Read more

JNTUK R16 percentage calculation

JNTUK R16 PERCENTAGE CALCULATION Here R16 batch students can calculate percentage according to obtained CGPA throughout the graduation. JNTUK introduced SGPA, CGPA in 2020 batch that is R16 REGULATION. Most of the companies ask percentage but students suffer how much percentage equal to obtained CGPA. for that here providing a wonderful platform for calculation of percentage by providing CGPA. ENETR CGPA BELOW BOX AND GET PERCENTAGE: ENTER CGPA    Percentage   For Lateral Entry students CGPA Calculator-  click here for Regular students CGPA Calculator -   click here Andhra Pradesh SI and Constable recruitment Notification 2022 Details - Click here for more details feel free to comment ...
Post a Comment
Read more

JNTUK R16 SGPA and CGPA calculator for Lateral entry b.tech

Lateral entry students those are joined directly engineering by completing polytechnic, they may or may not appeared for ECET for getting seat in engineering course. that is B.Tech students studied course in 4 years but lateral entry students studied course is 3 years, that one year spend in polytechnic course. Lateral entry students strong in Technically than regular students. for SGPA calculator -   click here NOTE: IF ANYONE WANT CALCULATE UPTO SOME SEMISTERS(LIKE UPTO 3-2) FOR PLACEMENTS CAN PROVIDE REMAINING SGPAS AND TOTAL CREDITS AS ZEROS(0) THEN WILL GET ACCURATE CGPA TILL THAT PARTICULAR SEMISTER. FOR LATERAL ENTRY SCHEME B.TECH CGPA IS... FIRST SEMISTER SGPA    total credits   SECOND SEMISTER SGPA    total credits   THIRD SEMISTER SGPA    total credits   FOURTH SEMISTER SGPA    total credits   FIFTH S...
1 comment
Read more