I have a Drop Down. Assume I select "Varia Single 25/2,3 90" Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned. List Pexflextra 25/2,3 90 Uno 25/2,3 76 MX-Radiflex 40/3,7 110 From above list the formula should return the first two values. I have been trying match, if, find but cannot get anything to work.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

From Drop Down lookup partial values

Thread starter thomasuponor
Start date Sep 13, 2018
Tags

25/2 drop down excel partial look up partial match

thomasuponor

New Member

Sep 13, 2018

I have a Drop Down. Assume I select "Varia Single 25/2,3 90"
Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned.

List
[TABLE="width: 235"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Pexflextra 25/2,3 90[/TD]
[/TR]
[TR]
[TD][TABLE="width: 235"]
<tbody>[TR]
[TD="width: 235"]Uno 25/2,3 76
[TABLE="width: 235"]
<tbody>[TR]
[TD="width: 235"]MX-Radiflex 40/3,7 110[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

From above list the formula should return the first two values.

I have been trying match, if, find but cannot get anything to work.