vlookup based off drop down options

[jmarcher]

Hello:
I have created two drop down lists. The first drop down provides seven options and then the second drop down gives options based on the first selection. After the second selection is made I have created a v-lookup below to display all information relating to this selection (around 10 columns worth and is pulled from another sheet) The problem I am having is several of records have the same language of the secod dropdown but only one record will pull in the v-lookup selection. I would like all the records to appear (the most is three) to show the viewer the different records.

Below is the formula used for the v-lookup data where C6 is the cell where the listbox option is selected.


=IFERROR(VLOOKUP(C6,'Raw Data'!E:O,11,FALSE),"")

Any help would be greatly appreciated!

 

[Akashwani]

Hi and welcome to MrExcel.

A VLOOKUP will not return more than one matching result.

Take a look here....

excelisfun -- Excel How To Videos - YouTube

Use a drop down list to search and return multiple values | Get Digital Help - Microsoft Excel resource
Vlookup – Return multiple unique distinct values in excel | Get Digital Help - Microsoft Excel resource

I hope that helps.

Ak

 

[jmarcher]

Hello:

Thank you for the response, but it is only one part that is the same the other columns are different. I thought we could do this with "Countif" but was not sure. Please let me know if this is an option I should or could consider for the original post's problem.

 

[Akashwani]

Hi,

Did you look at the links?

They cover most scenarios regarding looking up a value and returning multiple records.

Ak