How to return multiple entries based on a date range. with additional selection

Question

Hello, First time posting, but a long-time user. 

I am looking to sort by a date range and another field then return multiple options.

I used the index and match formula but only get one return...  

What I need is for the user to put in a date and from a dropdown they will select the "entry".  It should return multiple options.

This is as far as I have got.

Does anyone know how to update this to view multiple returns? The entry field can have something other then 1, i did not want to post company information so just put in general info.

Thank you

Answer 1

I don't follow what you are trying to do.

Here are some articles that may help

look for a value in a list in Excel? ****

look up a value and return the cell above or below in Excel? ****

lookup a value and return cell address in Excel? ****

lookup a value in 3D table in Excel? ****

lookup first non-zero value and return corresponding column header in Excel? ****

lookup latest or earliest date in Excel? ****

lookup partial string match in Excel? ****

lookup to return an active hyperlink in Excel? ****

lookup/find values in another workbook? ****

lookup value return multiple corresponding values in Excel? ****https://www.extendoffice.com/documents/excel/1979-excel-lookup-value-return-multiple-corresponding-values.html****This tutorial is talking about looking up a value return multiple corresponding values in Excel

---

return multiple lookup values in one comma separated cell? ****https://www.extendoffice.com/documents/excel/3120-excel-return-multiple-values-separated-by-comma.html

In Excel, we can apply the VLOOKUP function to return the first matched value from a table cells, but, sometimes, we need to extract all matching values and then separated by a specific delimiter, such as comma, dash, etc… into a single cell as following screenshot shown. How could we get and return multiple lookup values in one comma separated cell in Excel?

return the first / last non blank cell in a row or column? ****

VLOOKUP and return multiple corresponding values horizontally in Excel?

https://www.extendoffice.com/documents/excel/2623-excel-vlookup-return-multiple-values-horizontally.html

In default, VLOOKUP function can return multiple corresponding values in the vertical level in Excel, in some cases, you may want to return multiple values in horizontal level as below screenshot shown. Here I will tell you a formula can solve this task.

vlookup and return multiple values without duplicates in Excel?

https://www.extendoffice.com/documents/excel/5161-excel-vlookup-to-return-multiple-unique-values.html

Sometimes, you may want to vlookup and return multiple matched values into a single cell at once. But, if there are some repeated values populated into the returned cells, how could you ignore the duplicates and only keep the unique values when returning all matching values

VLookUp to return multiple columns from Excel table?

https://www.extendoffice.com/documents/excel/5334-excel-vlookup-to-return-multiple-columns.html

In Excel worksheet, you can apply the Vlookup function to return the matching value from one column. But, sometimes, you may need to extract matched values from multiple columns as following screenshot shown. How could you get the corresponding values at the same time from multiple columns by using the Vlookup function?

Vlookup to return multiple matches in Excel           2018 08 28   Svetlana Cheusheva

https://www.ablebits.com/office-addins-blog/2017/02/22/vlookup-multiple-values-excel/

When using Microsoft Excel for data analysis, you may often find yourself in situations when you need to get all matches based on a specific id, name, email address or some other unique identifier. An immediate solution that comes to mind is using the Excel VLOOKUP function, but the problem is that it can only return a single match.

Answer 2

Thank you I will look through these,.

My intent is to pull up data using a date range and another option.

Then to return all infomation in row c that matches that combination.

thank you

Answer 3

OK, that is a little bigger question, since you have multiple conditions to test. You will have to extend the formulas a bit more. Here are some articles to handle that part of the question.

Multi cond- Lookup based on multiple conditions?                     2010 11 02

https://chandoo.org/wp/2010/11/02/multi-condition-lookup/****Not always we want to lookup values based on one search parameter. For eg. Imagine you have data like below and you want to find how much sales Joseph made in January 2007 in North region for product “Fast car”?

ET MR LOOKUPs.docx

Multi cond- **Multi-Column Lookup with VLOOKUP and SUMIFS**             September 17, 2015          Jeff Lenning

When you need to perform a lookup, your instinct tells you to use VLOOKUP. But, when your lookup uses multiple conditions and columns, you may be inclined to use SUMIFS. However, when the value you need to return is a text string, rather than a numeric value, you are precluded from using SUMIFS since it only […]

Multi cond- The Ultimate VLOOKUP trick – Multi-condition Lookup October 28^th^, 2014 in ****http://chandoo.org/wp/2014/10/28/multi-condition-vlookup/

Presenting the Multiple criteria VLOOKUP! …boring…pass, we’ve seen it. Oh, have you? Not like this you haven’t. This will change the way you work with Excel. Easy. Let’s put a helper column in that concatenates the two inputs and do a basic VLOOKUP.

You are about to learn a VLOOKUP trick that Lucifer himself would not want you to know. It’s so absurdly powerful that it was developed in a lab and had to be tested on Rocky’s arch nemesis Ivan Drago.

ET MR LOOKUPs.docx

Multi cond- **VLOOKUP with Multiple Criteria******VLOOKUP is one of the most popular Excel Functions. But, it’s one of the most limited functions as well. Advanced Excel users know that there are so many things which we can’t do with VLOOKUP or  they need to put some extra efforts to make it work. For example: using VLOOKUP with multiple  criteria.By default, VLOOKUP allows […]

Multi-col- VLOOKUP Multiple Columns****

Multi-col- **VLOOKUP Multiple Values in Multiple Columns** May 16, 201  Mynda Treacy

A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited from a colleague who had left his company. It was a VLOOKUP formula like nothing I’d ever seen before so I thought I’d share it with you. Drum roll….. =VLOOKUP(E2&F2,IF({1,0},First_Name&Last_Name,Grade),2,FALSE) David’s question was ‘what’s the […]

Multi-col- **VLOOKUP Multiple Values**    December 7, 201    Mynda Treacy

For some of us we use the VLOOKUP function all the time and for the most part is does exactly what we want, but what if you want to lookup multiple columns? Taking the example below; in cell B3 I have a data validation list that allows me to choose the player I want to […]

Multi-cond- Advanced VLOOKUP formula examples: nested vlookup with multiple criteria, two-way lookup         2014 07 29             Svetlana Cheusheva

https://www.ablebits.com/office-addins-blog/2014/07/29/vlookup-formula-examples/

In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more.

Multi-cond- Do A Two-Way Lookup With INDEX and MATCHRun time: 3:17In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions...

Multi-cond- **Lookup With Two Criteria** **** May 26, 2016

http://blog.contextures.com/archives/2016/05/26/excel-lookup-with-two-criteria/

If you need to get a product price in Excel, you can use VLOOKUP or INDEX/MATCH to get the price from a lookup table, based on a product code. But what if you have…

Multi-cond- **Select Drop Down Item and use VLOOKUP to Return Multiple Attributes******October 2, 2014      Jeff Lenning

http://www.excel-university.com/select-drop-down-item-vlookup-return-multiple-attributes/

In this post, we’ll explore a method to allow a user to select an item from a drop-down list and then use formulas with the VLOOKUP function to retrieve multiple values from the related item table. Objective Before digging into the mechanics, let’s review our objective with an example.

******* Bonus ***********

Take a look a this article and tool. It may be able to help you develop the formula you need

! Vlookup Assistant for Excel – Preview/Beta (VBA tool)https://www.excelcampus.com/functions/vlookup-assistant-preview/

https://www.youtube.com/watch?v=g2_Yu_VRQ9E&feature=youtu.be

In this video, I share a preview of a new app called VLOOKUP Assistant, which makes it faster and easier to write lookup formulas like VLOOKUP and INDEX MATCH.

Download the example Excel file: https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.excelcampus.com%2Ffunctions%2Fvlookup-assistant-preview%2F&redir_token=XtCyIebTY9D3g4xZw3XdQxQFBPJ8MTU2NjU3NTIyNEAxNTY2NDg4ODI0&event=video_description&v=g2_Yu_VRQ9E

This tool is currently a set of VBA macros that will write lookup formulas for you.  It has two main features:

1. Create Lookup Formulas
2. Convert Lookup Formulas to Index&Match

PS: if you have Office 365, you can take a look at the new XLookup feature that is being released.  It is OK only as long as you don't have to share the workbook with users who do not have 365

@ Announcing XLOOKUP (365)          2019 08 28

https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376

https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/127917iF0B67B064B07CA2D/image-size/large

XLOOKUP is named for its ability to look both vertically and horizontally (yes it replaces HLOOKUP too!). In its simplest form, XLOOKUP needs just 3 arguments to perform the most common exact lookup (one fewer than VLOOKUP). Let’s consider its signature in the simplest form:

          XLOOKUP(What you are looking for, Where to find it, What to return)

Advanced XLOOKUP variations

.     match_mode allows you to set the type of match you’d like to perform.

.     .     Use zero to perform an exact match, this is the default.

.     .     Use 1 or -1 to allow a match against the nearest smaller (or larger) item when there is no exact match.

.     .     Use 2 to do a simple wildcard match where ? means match any character and * means match any run of characters

search_mode lets you configure the type and direction of search

.     .     Use 1 or -1 to search from first-to-last or last-to-first.

.     .     Use 2 or -2 to do a binary search on sorted data. This is included for expert users only.

@ XLOOKUP function (365, Online )

https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

Answer 4

Hi,

What exact result are you expecting in cell G2?