by 
nir
ANSWERS: 5
-
You use these functions when you have a table of data and you want to reference a part of that data. Sometimes data is organised in columns and sometimes it is organised in rows. The following example is looking at the value in cell A2 of the current workbook, finding that value in the first column of a named range (Suppliers) and returning the value from the third column of that row. FALSE returns an exact match and TRUE (or omitting this part) returns the closest match. =VLOOKUP(A2,Suppliers,3,FALSE) It is best if the lookup table is sorted in ascending order on the first column, and sometimes it is ESSENTIAL that it is sorted. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.
-
Good step by step: http://articles.excelyogi.com/vlookup-my-favorite-function/2008/10/23/
-
http://office.microsoft.com/en-us/excel/HP052093351033.aspx?pid=CH062528281033
-
1. Right-click your spreadsheet’s tab and select Insert… 2. On the Insert dialog, double-click Worksheet. This will be on the General tab. 3. Rename this new worksheet tab with a descriptive name such as “Party Codes” 4. In Column A, enter the unique values that exist on your main worksheet. In my example, these were the codes that showed in the Pcode column in the thumbnail. These values should be in ascending order. 5. In Column B, enter the translated value. You can have more values in column A than appear on your main spreadsheet. For example, I have an entry for “Citizen Party” even though I didn’t show a registered voter with that affiliation. Hope it helps.
-
This tutorial also helped me much to understand how vlookup works. Try it: http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC