When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.
excelsupersite.com
How to use the VLOOKUP Function in Excel | ExcelSuperSite
The vlookup function combined with the IF function would have to be some of the most used functions in all my Excel spreadsheets. The combination of these two functions allows me to “look up” pieces of information from a list and perform some comparative analysis on my data. Very powerful stuff when you get the hang of it.
