V Lookups

Hi Saroja!

The idea of a VLOOKUP is that in one cell you have a value or code e.g. an employee number in cell A2. Based on the value in A2 you want to bring in information about that employee held in a different data table.

1. Name this different table something e.g.EMPLOYEES and format it as a table if your company is growing.
2. Know which columns in the EMPLOYEES table you are interested in e.g. DeptName in column 3 and Salary in Column 6.
3. In cell B2 type your VLOOKUP formula:
=VLOOKUP(A2,EMPLOYEES,3,0)
to bring in the DeptName for the exact employee number you typed in cell A2.
4. In cell C2: =VLOOKUP(A2,EMPLOYEES,3,0) will bring in his salary.

Remember to nest this VLOOKUP inside an IF function to trap the blanks!

Hope this answers your question and thanks for the query.

Clare