K
Kaisa
A B C E F
1 SKU SUM SKU SUM
2 85 10 85 10
3 86 20 86 20
4 87 30 88 30
5 89 40
I'm trying to make a formula that can tell me the sum of each number. Like
her, that 85 picks out that it's 10 and so on. But at 88, which isn't in the
original list, it just takes the number above. I wish it could come up as an
error, when it doesn't exist.
The formula I have used here is: =VLOOKUP(D;A:B;2)
1 SKU SUM SKU SUM
2 85 10 85 10
3 86 20 86 20
4 87 30 88 30
5 89 40
I'm trying to make a formula that can tell me the sum of each number. Like
her, that 85 picks out that it's 10 and so on. But at 88, which isn't in the
original list, it just takes the number above. I wish it could come up as an
error, when it doesn't exist.
The formula I have used here is: =VLOOKUP(D;A:B;2)