Dear sourabh,
lookup function is used, when you're trying to use some calculation using a small parameter, vlookup = vertical lookup, so when you're using a vertical parameter you must use vlookup and hlookup for using horizontal parameter,so you act as if you had a small database which is used to help your formula.
I love vlookup!
Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:
Song# Title
123 Love Me Tender
234 Blue Suede Shoes
345 Dixie
Another worksheet has song number and performer in Row 1, Cols A:B
Song# Performer
123 Elvis Presley
234 Carl Perkins
456 Cher
Notice there is NO performer for song number 345 in the 2nd worksheet.
Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)
Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.
Help me out Mr. VLOOKUP.
Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)
Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.
That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.
That is why I prefer VLOOKUP over LOOKUP.
I have found this explaination of the VLOOKUP parameters helpful:
1. Needle (A2)
2. Haystack (Sheet2!A:B)
3. RELATIVE Col containing result (2)
4. Need DIRECT MATCH ONLY (0)
Hope this helps.
Let me know if you have any questions.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table
I have posted below link to know more .Please have a look..
I assume your question is regarding Microsoft Excel 2007. You have to use the Lookup Functions to get your data. Use the "VLookup" function to find out info matching the selection if your lookup data (i.e. data in the drop-down) is organized as rows and the linked data is in corresponding columns.
It is a function in excel that will look up to a value or data located in different sheet or in different cells. It is very helpful function to look for a bunch of data and compair and extract the exact information. syntax: =vlookup(lookup_value,table_array, col_index_num,[range_lookup])
I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.
The VLOOKUP function is a handy one to know when you want Excel to
lookup a value in one place and insert it in another. For example,
let’s say you have a list of all of your customers on a sheet named
“Accounts” and an invoice on another sheet named “Invoice”. When you
type in their account number on the Invoice, you want Excel to fill in
the name of the customer and their address (and this information is
included for all customers on the Accounts sheet). A VLOOKUP will do
this for you.
1024x768
Normal
0
false
false
false
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
These are Excel functions for Lookup tables. The purpose of
Lookup tables is to bring a value to the table, find the closest (or exact)
match, and then return another value.
An example is the federal income tax table. On your tax
return you get your gross income and number of dependents, go to the Lookup
table, and find your taxable income.
The V in VLOOKUP means that the table is vertical; HLOOKUP
has a horizontal orientation.
If you use the Insert Function button in Excel and paste
either function, the dialog box will explain each required field separately
with examples.
Are you referring to the VLOOKUP function in Microsoft Excel?
I love vlookup!
Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:
Song# Title 123 Love Me Tender 234 Blue Suede Shoes 345 Dixie
Another worksheet has song number and performer in Row 1, Cols A:B
Song# Performer 123 Elvis Presley 234 Carl Perkins 456 Cher
Notice there is NO performer for song number 345 in the 2nd worksheet.
Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)
Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.
Help me out Mr. VLOOKUP.
Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)
Copy
that cell to row 3 and row 4 Col C. You should get the performer names
for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.
That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.
That is why I prefer VLOOKUP over LOOKUP.
I have found this explaination of the VLOOKUP parameters helpful:
1. Needle (A2) 2. Haystack (Sheet2!A:B) 3. RELATIVE Col containing result (2) 4. Need DIRECT MATCH ONLY (0)
Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:
Song# Title 123 Love Me Tender 234 Blue Suede Shoes 345 Dixie
Another worksheet has song number and performer in Row 1, Cols A:B
Song# Performer 123 Elvis Presley 234 Carl Perkins 456 Cher
Notice there is NO performer for song number 345 in the 2nd worksheet.
Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)
Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.
Help me out Mr. VLOOKUP.
Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)
Copy
that cell to row 3 and row 4 Col C. You should get the performer names
for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.
That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.
That is why I prefer VLOOKUP over LOOKUP.
I have found this explaination of the VLOOKUP parameters helpful:
1. Needle (A2) 2. Haystack (Sheet2!A:B) 3. RELATIVE Col containing result (2) 4. Need DIRECT MATCH ONLY (0)
×