#WHAT IS VLOOKUP IN EXCEL 2016 TRIAL#
Note: If the value is not found in the data range, you will get an error value #N/A.ĭownload and free trial Kutools for Excel Now ! You just need to drag the fill handle to apply this formula to other cells you need,see screenshot: Then click Ok, and the first matched data based on a specific value has been returned at once.