Theyre both using similar data sets but since were pulling information from two separate columns 3 and 2 we make that distinction at the end of the formulathe first one grabs the position of the person in A8 Finley while the second formula returns the name that matches the employee number in A9 819868. The default is TRUE allow non-exact match. The HLOOKUP function can return approximate or exact matching and use wildcards or.
To speed things up you can sort the names alphabetically but if you have many clients with last names starting with w you might still get a headache browsing the list.
This is the area where Excel will search for the Full name column so well select the data we want to search for both the column name and the specified cell. This is the area where Excel will search for the Full name column so well select the data we want to search for both the column name and the specified cell. 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. Lookup_value can be a value a reference or a text string.