How to get started Vlookup

There are four pieces of information that you will need in order to build the VLOOKUP syntax:

The value you want to look up, also called the lookup value.

The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.

The column number in the range that contains the return value. For example, if you specify B2:D11 as the range, you should count B as the first column, C as the second, and so on.

Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you don’t specify anything, the default value will always be TRUE or approximate match.

Now put all of the above together as follows:

=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

Example-1

Example-2

How to do Vlookup from different sheet for mobile number?

Everyone knows the basics of the VLOOKUP function in Excel. Perhaps for beginner level, you will need to practice formulas on the same sheet. taking data from another sheet or another workbook is slightly different from Excel’s VLOOKUP function. Let’s see how to use the VLOOKUP function in another sheet and how to use it in another workbook.

How do VLOOKUP from another sheet but the same Workbook?

Generic formula ( =VLOOKUP(lookup,sheet!range,column,match)

Please check below Example:

In below snap we have two sheets like “COMPLETE DETAILS” and “Results”,If we refer COMPLETE DETAILS” there we have Name,Mobile number and Address.

and now if we refer “Results” sheet , we have names in column “A” and we are looking for their mobile numbers in column “B”

so now we will apply VLOOKUP function in the Results sheet column “B” and select the lookup value as Cell A2.

Now the table array is on a different sheet here we have to select COMPLETE DETAILS’!A:C. (Please do not type manually)

Please enter the column index (reference) in our case it will be 2 and the match condition(range looktype) will be false. now our complete formula will be like below

=VLOOKUP(A2,’COMPLETE DETAILS’!A:C,2,FALSE) and Enter refer below snap

We got the results from the other worksheet.Please refer below snap.

Thanks for the reading.

By admin

4 thoughts on “How use VLOOKUP Step by Step with example🌟🌟?”
  1. Your style is so unique in comparison to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this site.

Leave a Reply

Your email address will not be published.