Beto
07-27-2018, 02:28 PM
Alright, I am trying to bring back the most recent (highest DEX value) unit cost from a SQL table in Excel that matches an item number.
TRIMMEDITEMBR
DATERECD
UNITCOST
DEX_ROW_ID
393175722
8/7/2007 0:00
3.39
1
393175722
8/7/2007 0:00
3.47
2
393175622
8/7/2007 0:00
3.39
3
393175622
8/7/2007 0:00
3.63
4
=INDEX(_IV10200[UNITCOST],MATCH(393175722),_IV10200[TRIMMEDITEMBR],0)
I feel like i need another MATCH with a MAX, an array? tied into the INDEX?
The other issue is that in the TRIMMEDITEMBR there are also, of course multiple different item numbers. I would like to base the MAX value on the DEX ROW ID and match the item number and bring back the unit cost.
Does this make sense?
Thanks in advance! You guys are always super helpful!
-Beto
TRIMMEDITEMBR
DATERECD
UNITCOST
DEX_ROW_ID
393175722
8/7/2007 0:00
3.39
1
393175722
8/7/2007 0:00
3.47
2
393175622
8/7/2007 0:00
3.39
3
393175622
8/7/2007 0:00
3.63
4
=INDEX(_IV10200[UNITCOST],MATCH(393175722),_IV10200[TRIMMEDITEMBR],0)
I feel like i need another MATCH with a MAX, an array? tied into the INDEX?
The other issue is that in the TRIMMEDITEMBR there are also, of course multiple different item numbers. I would like to base the MAX value on the DEX ROW ID and match the item number and bring back the unit cost.
Does this make sense?
Thanks in advance! You guys are always super helpful!
-Beto