Question about Business & Productivity Software
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:
123 Love Me Tender
234 Blue Suede Shoes
Another worksheet has song number and performer in Row 1, Cols A:B
123 Elvis Presley
234 Carl Perkins
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.
Posted on Jan 08, 2008
Tips for a great answer:
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Dec 03, 2008 | Microsoft Office Professional 2007 Full...
Jul 08, 2008 | Microsoft Business & Productivity Software
Jun 10, 2008 | Microsoft Excel for PC
Apr 19, 2008 | Microsoft Office Professional 2007 Full...
Jan 12, 2008 | Microsoft Office Standard for PC
Oct 21, 2016 | The Business & Productivity Software
329 people viewed this question
Usually answered in minutes!