vlookup with two digit criteria with multiple text results
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
Last edited by Gmiller0503; 03-09-2017 at 09:35 AM.
Reason: to clarify
|