Sean has attended:
Excel Intermediate course
Vlookups
Not too sure about how to set up a vlookup. May need further advice/help.
RE: vlookups
Dear Sean
Thank you for attending the Excel Intermediate course.
VLookup is basically a function that can help you to retrieve data from a table that may have lots of information. Please note that if you can only use Vlookup if the column headings in the table are arranged vertically. Normally people have the data arranged in this format.
If the main headings are arranged in rows then you have you use the HLookup.
Please refer to the file that I have uploaded for the below mentioned explanation:
If you notice Cell Range A9:F49 is the main table.
A6 is the cell which other cells on the right will refer to display the result. Therefore, this will be our Lookup value.
In Cell B6 I entered the following formula:
=VLOOKUP(A6,A9:F49,2,FALSE)
Let