Archive for the ‘Vlookup’ Category
The array formula in cell E6 filters values in column C based on value in cell E3, the output is […]
The array formula in column G filters values in column C using a condition in cell E3, comparing it with […]
Table of Contents Overview Arguments Approximate match Related tables Dynamic arguments INDEX + MATCH VLOOKUP error VBA Example Using multiple […]
Pat asks: Hi Oscar, Thanks for creating such a helpful website and I've a question if I would like to […]
Table of contents Lookup multiple values in different columns and return a single value Lookup multiple values in different columns […]
Ainslie asks: I have multiple worksheets in an excel book. I have a drop down menu on the worksheet entitles […]
This post describes how to search visible values and return multiple values from a table. Some rows are hidden because […]
Ahmed Ali asks: How to return multiple values using vlookup in excel and removing duplicates? I have tried the formula […]
Mr.Excel had a "challenge of the month" June/July 2008 about Wildcard VLOOKUP: "The data in column A contains a series […]
Array formula in D4: =INDEX($A$1:$A$7, SMALL(IF(EXACT($A$1:$A$7, $E$1), ROW($A$1:$A$7), ""), ROW(A1))) + CTRL + SHIFT + ENTER. Copy cell D4 and […]
Linda asks in this post: How to return multiple values using vlookup in excel I tried using the formula above […]
In this post we are going to extract multiple text values. We are looking for names and the criteria are […]
I found a question in the comments section. You can find the question in this post: Lookup values in a […]
In a previous blog post Sum adjacent values using multiple lookup text values in a column in excel I created […]
In a previous blog post Extract cell values in a range using a criterion in excel I provided a formula […]
Here is a follow up to this previous post: Vlookup with 2 or more lookup criteria and return multiple matches […]
VLOOKUP and return multiple matches based on many criteria.
Question: Hi, The formula here works great but I can't figure out how to change it to work with data […]
This post explains how to lookup a value and return multiple values. No array formula required.
Lookup with criteria and return records.
Question: How do i return multiple results for one lookup value? I have tried to use multiple vlookups, with no […]