|
|
#1
03-09-2017, 09:34 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula (possibly something like VLOOKUP) that will return multiple results. | SilverUnicorn79 | Excel | 8 | 08-16-2016 01:34 PM |
 A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
| excel vlookup with multiple criteria | mpokorny | Excel | 4 | 05-06-2012 04:06 AM |
|
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
| Sum Product Multiple Text and date Criteria | ramki | Excel | 1 | 01-09-2012 01:16 AM |
Windows 7 32bit 
Office 2013
Threaded Mode