medium10 pts · first answer countsexcelxlookup

Latest price for a product

A price log adds a new row each time a price changes, oldest at the top. Which formula returns the most recent price for the product in F2?

A.=XLOOKUP(F2,A:A,C:C,,0,1)B.=XLOOKUP(F2,A:A,C:C,,-1)C.=XLOOKUP(F2,A:A,C:C,,0,-1)D.=VLOOKUP(F2,A:C,3,FALSE)+0

Discussion 0

Join free to post in the discussion.