I have an excel spreadsheet that gets realtime data from a program. The values change in 2 columns. For example, product# and price would be the two columns. There are about 20 products total for which price data accumulates. Here is a sample sheet"
product# price
__________________
4567 6.13
3325 1.97
4657 2.22
3326 3.77
1147 4.88
The feed I get is only 1 row and has product and price, for example:
product# price
__________________
3326 7.77
the product and price are always changing, but the product# will always be one of twenty products I have.
I am trying to use a vlookup function to calculate total price sums over a day's period by looking up the product# but when I use the vlookup function it does not update, its like a static function and the data is constantly changing
product# price
__________________
4567 6.13
3325 1.97
4657 2.22
3326 3.77
1147 4.88
The feed I get is only 1 row and has product and price, for example:
product# price
__________________
3326 7.77
the product and price are always changing, but the product# will always be one of twenty products I have.
I am trying to use a vlookup function to calculate total price sums over a day's period by looking up the product# but when I use the vlookup function it does not update, its like a static function and the data is constantly changing
