Question about Microsoft Office Standard for PC
What is lookup & vlookup function in excel & how can we use it.
May I know the Formula for the VLOOKUP
Posted on Oct 18, 2008
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.
Posted on Aug 27, 2007
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.
Posted on Aug 27, 2007
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 14, 2011 | Microsoft Excel for PC
Feb 28, 2011 | Microsoft Office Computers & Internet
Aug 27, 2010 | Computers & Internet
Jun 21, 2009 | Microsoft Computers & Internet
Jun 12, 2009 | Microsoft Excel for PC
Feb 18, 2009 | Microsoft Computers & Internet
Dec 02, 2008 | Microsoft Excel for PC
Jan 07, 2008 | Computers & Internet
Oct 10, 2007 | Microsoft Office Standard for PC
248 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: