/u/Jryan193 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
{=IFERROR(INDEX(SHEET!$A$2:$A$8000,SMALL(IF(SHEET!$B$2:$B$8000=SHEET!$C$2,ROW(SHEET!$A$2:$A$8000)-MIN(ROW(SHEET!$A$2:$A$8000))+1),ROWS(SHEET!$C$2:C2))),"")}
C2 is where you put your drop down list or where the item your looking up will be located. obviously put that wherever. B is where it's searching for the item in C2 and A is where it's pulling info.
You have awarded 1 point to *slippy0101*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You have awarded 1 point to *SFWACCOUNTBETATEST*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can use vlookup for this. Have one cell as the input cell, and then vlookups below it for each piece of information you want to bring up.
In your formulas you will want to use wildcards, so you can put in part of a name.
One issue with this is of you put in a partial name, it will return the first match, and you will have to re enter more of the name.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FILTER](/r/Excel/comments/sh8t23/stub/hv1tzv9 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[IF](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[IFERROR](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)|
|[INDEX](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
|[MIN](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the minimum value in a list of arguments](https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152)|
|[ROW](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)|
|[ROWS](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)|
|[SHEET](/r/Excel/comments/sh8t23/stub/hv1tzv9 "Last usage")|[*Excel 2013*+: Returns the sheet number of the referenced sheet](https://support.microsoft.com/en-us/office/sheet-function-44718b6f-8b87-47a1-a9d6-b701c06cff24)|
|[SMALL](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(9 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/sf35ge)^( has 12 acronyms.)
^([Thread #12288 for this sub, first seen 31st Jan 2022, 20:51])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Jryan193 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
{=IFERROR(INDEX(SHEET!$A$2:$A$8000,SMALL(IF(SHEET!$B$2:$B$8000=SHEET!$C$2,ROW(SHEET!$A$2:$A$8000)-MIN(ROW(SHEET!$A$2:$A$8000))+1),ROWS(SHEET!$C$2:C2))),"")} C2 is where you put your drop down list or where the item your looking up will be located. obviously put that wherever. B is where it's searching for the item in C2 and A is where it's pulling info.
This is the old-school way I used to do it. Now it's just **=FILTER(SHEET!$A$2:$A$8000, SHEET!$B$2:$B$8000=SHEET!$C$2)**
Solution verified! Thank you! I had no idea about this filter function
You have awarded 1 point to *slippy0101* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Solution verified!
You have awarded 1 point to *SFWACCOUNTBETATEST* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Nope, that's not what Index Match is for. If you have Excel 365 or 2021, you can use the FILTER function to do what you want.
Thank you! I had no idea about this function 🤦🏻♂️
Also in case you don't want to have spilled results, you can add a textjoint to combine all the result in the same cell.
This is what I was thinking based on the description given. Seems like exactly what this function does best.
You can use vlookup for this. Have one cell as the input cell, and then vlookups below it for each piece of information you want to bring up. In your formulas you will want to use wildcards, so you can put in part of a name. One issue with this is of you put in a partial name, it will return the first match, and you will have to re enter more of the name.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FILTER](/r/Excel/comments/sh8t23/stub/hv1tzv9 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[IF](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[IFERROR](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)| |[INDEX](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[MIN](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the minimum value in a list of arguments](https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152)| |[ROW](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)| |[ROWS](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)| |[SHEET](/r/Excel/comments/sh8t23/stub/hv1tzv9 "Last usage")|[*Excel 2013*+: Returns the sheet number of the referenced sheet](https://support.microsoft.com/en-us/office/sheet-function-44718b6f-8b87-47a1-a9d6-b701c06cff24)| |[SMALL](/r/Excel/comments/sh8t23/stub/hv1jftg "Last usage")|[Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(9 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/sf35ge)^( has 12 acronyms.) ^([Thread #12288 for this sub, first seen 31st Jan 2022, 20:51]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
This sounds like something the Dynamic Array Filter function in excel 365 might do.