Hi



I need help with a vlookup formula.

I am trying to search in a column for numbers starting with a certain two digits, returning multiple results from another column with text.

Example:

ID Name
11 Bob
12 Bill
13 Betsy
110 Beverly
121 James
134 Janet

looking for a formula to group these in a list resembling this:

ID Name
11 Bob
110 Beverly
12 Bill
121 James
13 Betsy
134 Janet

Can't you just sort the ID Names?

hi! No I cannot just use sort because it will use any length of ID numbers with those two digits, not just the ones with the two digits as first two in ID number.

For example, if I searched for "15", it could show results like "15", "151", but also "4615" or "321516" which the two digits are contained in the ID number but not the first two digits.

I can send a spreadsheet if easier?

I answered based on the data you gave and sorting your example gives exactly your wanted list.