In this case, the database didn’t contain any sort of unique identifier or information. “But why even bother combining information in the database?”ĪNY look up function needs a unique piece of information to work. So combining last name and date of birth is the smarter choice as this creates a unique identifier in most cases. There are two David Jones’ in our data, but only one employee with last name Jones and birthdate 07-23-1991. However, if we combine “Last name” and “Date of birth” we would get Jones 07-23-1991. If we combine “First name” and “Last name” we might end up with a David Jones. However combining last name AND date of birth greatly increases the chances of finding a unique value. Unfortunately, none of the information in the employee database is unique, not even last name or date of birth. You might recall that I told you that any lookup function needs to look for a unique piece of information. After this, I mark where I want my criteria and where the formula goes by writing “Last name” in I2, “Date of birth” in I3 and “Salary” in i4.Īdditionally, I hold the left mouse button down on the line between the column names and drag to make them wider, so that the entire content of the cell fits.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |