Skip to main content

Excel Tips: Calculation & Formulas > Look for a Value

Vlookup

Vlookup and Return Multiple Matched Values

How to list all matched instances of a value in Excel?

How to lookup value return multiple corresponding values in Excel?

How to return multiple lookup values in one comma separated cell?

How to use vlookup and sum in Excel?

How to use VLOOKUP to create a unique list from table in Excel?

How to vlookup across multiple sheets and sum results in Excel?

How to vlookup and concatenate multiple corresponding values in Excel?

How to VLOOKUP and return multiple corresponding values horizontally in Excel?

How to vlookup and return multiple matching values at once in Google sheet?

How to vlookup and return multiple values from drop down list?

How to vlookup and return multiple values without duplicates in Excel?

How to vlookup find the first, 2nd or nth match value in Excel?

How to vlookup the last or first matching value in Excel?

How to vlookup to return multiple columns from Excel table?

How to vlookup to return multiple values in one cell in Excel?

Vlookup and Return Special Value

How to lookup to return an active hyperlink in Excel?

How to vlookup and return background color along with the lookup value in Excel?

How to vlookup and return date format instead of number in Excel?

How to vlookup and return whole / entire row of a matched value in Excel?

How to VLOOKUP and return zero instead of #N/A in Excel?

How to vlookup to get the row number in Excel?

How to vlookup to return blank instead of 0 or N/A in Excel?

How to vlookup value and return true or false / yes or no in Excel?

Vlookup by Max or Min Value

How to find the highest value and return adjacent cell value in Excel?

How to find the item with the largest sum in a table range?

How to vlookup next largest value in Excel?

How to VLOOKUP the lowest value and return adjacent cell in Excel?

Vlookup in Special Order

How to apply negative vlookup to return the value in left of the key field in Excel?

How to backwards vlookup in reverse order in Excel?

How to display the corresponding name of the highest score in Excel?

How to find matched value by searching upwards in Excel?

How to reverse vlookup function in Google sheet?

How to vlookup matching value from bottom to top in Excel?

How to vlookup values from right to left in Excel?

Vlookup in Special Range

How to lookup/find values in another workbook?

How to merge and update table from another table in Excel?

How to merge two sheets by using VLOOKUP in Excel?

How to merge two tables by matching a column in Excel?

How to vlookup and return matching value in filtered list?

How to vlookup and return matching value with cell comment?

How to vlookup matching value from another google sheet?

How to vlookup to another workbook?

How to vlookup to compare two lists in separated worksheets?

How to vlookup values across multiple worksheets to return sheet names in Excel?

How to vlookup values across multiple worksheets?

Vlookup with Case Sensitive

How to do a case sensitive vlookup in Excel?

How to VLOOKUP value case sensitive or insensitive in Excel?

Vlookup with Special Criteria

How to lookup a value in 3D table in Excel?

How to lookup partial string match in Excel?

How to return a value if a given value exists in a certain range in Excel?

How to return cell value based on multiple criteria in Excel?

How to use two-way lookup formula in Excel?

How to vlookup and return matching data between two values in Excel?

How to vlookup between two dates and return corresponding value in Excel?

How to vlookup in two dimensional table in Excel?

How to vlookup numbers stored as text in Excel?

How to vlookup value with multiple criteria in Excel?

How to vlookup wildcard (~, *, ?) literally in Excel?

How to VLOOKUP with drop down list in Excel?

Others

How to autofill VLOOKUP in Excel?

How to look for a value in a list in Excel?

How to return value in another cell if a cell contains certain text in Excel?

How to use vlookup exact and approximate match in Excel?

How to vlookup return value in adjacent or next cell in Excel?

How to VLOOKUP then multiply in Excel tables?