|
|
#5
03-29-2021, 02:12 PM
|
||||
|
||||
I think Purfleet's solution will work for you if you use his
=MATCH([@Name2],[Name2],0) in E2 (copy down if it doesn't happen automatically). Then refresh your qUnique table. Leave your VLOOKUP as it is in column G. The numbers don't have to be contiguous values for this. Without the qUnique table, try in column G =INDEX([Name],MATCH([@NameCode]&"N",[NameCode]&[Name3],0)) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Assigning shortcut to Original mode in Tracking group | Editor | Word | 3 | 05-26-2019 07:12 AM |
 Assigning the Legend to Data Columns
|
jelkin1 | Excel | 1 | 12-10-2015 06:12 AM |
| Linking/Assigning Excel data 2 shapes (Timeline functionality) | mediaset23 | Visio | 0 | 07-31-2015 04:18 AM |
| Trying to autofilter 8-10 rows of numbers to sort in a group | Jack-P-Winner | Excel | 0 | 11-25-2013 10:55 PM |
| Assigning a single task to a team or group | djcozens | Project | 1 | 07-09-2012 05:44 AM |
Windows 10 
Office 2019
Threaded Mode