Excel's VLOOKUP function is used to find and return
information from a table of data based on a lookup value that you choose.
Normally, VLOOKUP requires the lookup value to be in the
left-most column of the table of data, and the function returns another field
of data located in the same row to the right of this value.
By combining VLOOKUP with the CHOOSE function
The steps detailed below create the left lookup formula seen
in the image above.
The formula
The job of the CHOOSE function in the formula is to trick
VLOOKUP into believing that column 3 is actually column 1. As a result, the Employee
ID can be used as the lookup value to find the name of the department name.
Enter the following headings into the cells indicated:
Column “C” shows the Employee ID
Column “B” Shows the Department
No comments:
Post a Comment