Question about Microsoft Office Standard for PC
Vlookup: =VLOOKUP(A1,A1:C10,3,FALSE) 1. Lookup_value - A1 the value you want to search. 2. Table_Array - A1:C10 You will only search the lookup_value in the left column which is A1:A10 in this example. 3. Col_Index_Number - If you find a matching value give me column 3. Since A1=A1 it will give me C1. In this example 1 is A, 2 is B and 3 is C. 4. Range_lookup - I always choose false which is exact match. True will give you approximate match and its not always correct. Vlookup is used when you have a list of values and you want additional values that exist in other fields. You will get those values only for the fields that you search for. In your example you can get the address by running vlookup at the names, it is also good way to search duplicates. Q2 is very simple, on field D1 just type: =A1 & " " & B1 & " " & C1 Just drag it or double click on the drag square Let me know if you have any other questions Daniel
Posted on Sep 24, 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:
Jul 14, 2017 | The Computers & Internet
Feb 15, 2013 | Microsoft Excel for PC
Jun 12, 2009 | Microsoft Excel for PC
Dec 29, 2008 | Microsoft Office Home and Student 2007...
Jul 12, 2008 | Excel (SS8SATAS5128400R)
Feb 03, 2008 | Microsoft Excel for PC
Oct 10, 2007 | Microsoft Office Standard for PC
Aug 30, 2007 | Microsoft Office Standard for PC
95 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: