Hello, I’m trying to bring the fuel price from the “Preturi combustibil” to the “Registru Productie” according to the last entered date and the car’s registration number. My problem is that the car is not refueled at the gas station every day and when the date is between the 2 refueling (for examp…

I think a query with with conditions to match, License Plate is This Row → License Plate l, and Date is on or before This Row → Date, should work. Set the query sorting to sort ascending by date and only return 1 row. Then use a Single Value column to retrieve the fuel price from the query.

Query problem

Ask for Help

Darren_Murphy January 28, 2024, 8:34am 3

Isn’t this basically the same problem that we already solved below?

Topic		Replies	Views
Formula to show the latest fuel price? Ask for Help	12	217	December 11, 2022
Help with a google sheet query for a billing app Ask for Help	24	1572	May 22, 2020
Perform logic on related data (last order) Ask for Help	4	230	January 17, 2024
Display the latest item from my sheet Ask for Help	9	761	October 13, 2019
Condition with column value on the right as well Feature Requests	0	216	May 12, 2020

Query problem

Related topics