Suppose I am looking up value X. Value X appears 5 times on another spreadsheet with 5 different dollar amounts for each of the 5 X's that occur. The dollar amounts are: $1000, $2000, $2000, $2000 and $5000.
The VLOOKUP is stopping at the first X ($1000) and returning $1000. I would like for the VLOOKUP to consider all X's and return the total of all X's which is $12000.
Is there a way to do this?
The VLOOKUP is stopping at the first X ($1000) and returning $1000. I would like for the VLOOKUP to consider all X's and return the total of all X's which is $12000.
Is there a way to do this?
