gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
I'm trying to get a list of names.
I've tried index,match and vlookup, but how can you 'go to next listing'?
I should have 3 names, 3 names, 2 names. Use either formula or one of your own.
thank you.
I'm trying to get a list of names.
I've tried index,match and vlookup, but how can you 'go to next listing'?
I should have 3 names, 3 names, 2 names. Use either formula or one of your own.
thank you.
NBA.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | Team: | POR | ATL | PHX | ||
3 | Injuries: | 3 | 3 | 2 | ||
4 | Who: | Zach Collins | Bogdan Bogdanović | Cameron Payne | ||
5 | Zach Collins | Bogdan Bogdanović | Cameron Payne | |||
Injuries |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:D2 | B2 | =LOOKUP(2, 1/((COUNTIF($B$2:B2,Favs!$A$4:$A$29)=0)*(Favs!$A$4:$A$29<>"")),Favs!$A$4:$A$29) |
B3:D3 | B3 | =COUNTIF('Injury List'!$A:$A,B2) |
B4:D4 | B4 | =INDEX('Injury List'!$B:$B,MATCH(Injuries!B$2,'Injury List'!$A:$A,0)) |
B5:D5 | B5 | =VLOOKUP(B$2,'Injury List'!$A:$B,2,0) |