lOOKUP INTO TABLE IF GREATER THAN A DATE

[cogswel__cogs]

Hi,
I need to pull pricing from a table that has Material # (ColA), Date Price was change(ColB) and the price (ColC).

I want to pull for material based on a date of purchase.

The table referenced is not sorted by material currently as it list of chronological price changes thus it is sorted by date.

As always help is greatly appreciated.

 

[cogswel__cogs]

Worked around this.

I start with a (IF) match to make sure that the prod actually exists.
Once I confirm that I just vlookup concatenated prod code with price (True) so it pulls closet match that does not exceed.