|
|
|
|
#1
09-21-2016, 01:55 AM
|
||||
|
||||
You have to adapt the lookup value in cells C11 15 and 19
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#2
09-21-2016, 06:19 PM
|
|||
|
|||
|
Hi pecoflyer, I should be clearer in the issue i had encountered.
i did what you said, but doesn't seems to be able to do that. when the grouping are "A,B,C,D" when i put any of them to lookup in C11, it works, but when i change it to "Team 1, Team 2, Team 3, team 4" and i put the indentical input to C11. it doesn't work...
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| index / match Formula | dmcg9760 | Excel Programming | 1 | 11-08-2015 03:16 PM |
| find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
| Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode