Forum Discussion
Problem with function vlookup
Hi everyone! In my excel i pretend search a material in a column B (with vlookup) that contain some lines of components in column C and the suppose is select and copy those components that start wi...
=INDEX(C$2:C$10,SMALL(IF(($B$2:$B$10=$B$14)*((LEFT($D$2:$D$10,4)=$A$14)+(LEFT($D$2:$D$10,4)=$A$15)+(LEFT($D$2:$D$10,2)=$A$16)),ROW($D$2:$D$10)-1),ROW($A1)))You can try this formula in the english version of e.g. Excel 2013. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell C14 and filled across range C14:E17.
If you work with Office 365 or Excel 2021 you can apply the FILTER function.