$A$2:$B$255) Do not include column headersħ col_index_num The column number in the table array from which the matching value must be returned. (Put a $ before the letters and numbers in the references, i.e. If the table is not sorted in ascending order on the first column, the function can give unpredictable results. If lookup_value is smaller than the smallest value in the first column of the table array, VLookup returns the #N/A error value. We’ll talk about VLookup today.ĥ lookup_value The value to search for in the first column of the table array. Range_lookup) What you’re looking for Where you’re going to look What you want to know Is ‘close’ good enough? HLookup has the same syntax, with “row_index_num” instead of “col_index_num”. El Paso Ellis Fannin Fort Bend Galveston 4 2 1Ĥ Syntax VLOOKUP (lookup_value, table_array, col_index_num, Collingsworth 1 Comanche Dallas 16 Denton 6 El Paso 4 Ellis 2 Fannin Fort Bend Galvestonģ HLookup Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Your first session is always free.Īre you still looking for help with the IF function? View our comprehensive round-up of IF function tutorials here.Presentation on theme: "VLookup and HLookup in Microsoft Excel"- Presentation transcript:Ģ VLookup Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Combined with the IF function, VLOOKUP can perform more advanced lookups that help to analyze data more effectively. It is a very powerful lookup and reference function for looking up data. According to this condition, the VLOOKUP then returns the corresponding price for the product.Įxcel has several very effective functions when it comes to lookup values in other columns. The IF function checks if the value in cell F2 is Shop 1 or 2.
#Vlookup in excel how to#
Learn How to Combine IF Function with VLOOKUP