Thread: vlookup with two digit criteria with multiple text results
View Single Post
 
Old 03-09-2017, 09:34 AM
Gmiller0503 Gmiller0503 is offline Windows 7 32bit Office 2013
Novice
  
Join Date: Mar 2017
Posts: 2
Gmiller0503 is on a distinguished road
Default 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
Reply With Quote