VinceF
Board Regular
- Joined
- Sep 22, 2007
- Messages
- 172
- Office Version
- 2016
- Platform
- Windows
Greetings Experts and Thank You in advance.
I'm trying to combine these two formulas without much sucess, assistance appreciated.
In E5 you'll see this formula to match the players in the column with the value from the other sheet "Player Quota History"
IF(Main!$B5="","",INDEX('Player Quota History'!D5:D12,MATCH(Main!$B5,'Player Quota History'!B5:B12,0)))
In G5 this formula reports the last value in the specific row.
LOOKUP(2,1/('Player Quota History'!D5:H5<>""),'Player Quota History'!D5:H5)
I'm going to attempt to show both sheets using Xl2bb
VinceF
Excel 2016
I'm trying to combine these two formulas without much sucess, assistance appreciated.
In E5 you'll see this formula to match the players in the column with the value from the other sheet "Player Quota History"
IF(Main!$B5="","",INDEX('Player Quota History'!D5:D12,MATCH(Main!$B5,'Player Quota History'!B5:B12,0)))
In G5 this formula reports the last value in the specific row.
LOOKUP(2,1/('Player Quota History'!D5:H5<>""),'Player Quota History'!D5:H5)
I'm going to attempt to show both sheets using Xl2bb
VinceF
Excel 2016
Sample.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
3 | ||||||||||
4 | ||||||||||
5 | Bob | 3 | 4 | 1 | ||||||
6 | Curly | 2 | 1 | |||||||
7 | Joe | 5 | 7 | |||||||
8 | Larry | 4 | 6 | |||||||
9 | Mike | 1 | ||||||||
10 | Moe | 9 | ||||||||
11 | Pete | 5 | 8 | |||||||
12 | Sam | 2 | 7 | |||||||
13 | ||||||||||
14 | ||||||||||
15 | ||||||||||
16 | ||||||||||
17 | ||||||||||
Player Quota History |