Forum Discussion

Iron Contributor

Jul 31, 2019

Find next price in data set

Hi, I have a series of data which involves a range of products. I am aiming to find the price for each product in the set of data. I have attached an example. Can someone please assist. K...

Find next price question.xlsx9 KB

BI & Data Analysis

excel

Excel on mobile

Formulas and Functions

Macros and VBA

power bi

Twifoo

Silver Contributor

Jul 31, 2019

calof1

Given the Stock and Date in F3 and F4, respectively, the formula in F5 to return the next price is:

=LOOKUP(2,1/((A3:A7=F3)*(B3:B7>F4)*B3:B7=AGGREGATE(15,6,
1/((A3:A7=F3)*(B3:B7>F4))*B3:B7,1)),
C3:C7)

For an unknown reason, I cannot attach the file despite several attempts to do so. There must have been a bug when the manner, by which files shall henceforth be attached, was modified.

calof1

Iron Contributor

Aug 01, 2019

HiTwifoo

Thanks for the message.

I was able to use the formula without the example, thank you for your time and assistance, it also solved my needs.

Much appreciated.