Question about Microsoft Office Standard for PC
Hi sir, pls tell me use vlookup formulla . thanks & Regards Devendra kumar rawal
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 Oct 10, 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
Jun 30, 2008 | Computers & Internet
Jun 25, 2009 | Microsoft Excel for PC
Jun 21, 2009 | Microsoft Computers & Internet
Feb 18, 2009 | Microsoft Computers & Internet
Dec 02, 2008 | Microsoft Excel for PC
Aug 30, 2007 | Microsoft Office Standard for PC
350 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: