You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
MAXIFS is your friend here
column a = standard
column b = rating
column c = resistance
turn that into a table and then
=MAXIFS(Table1[Resistance],Table1[Standard],G3,Table1[Rating],H3)
where you put in the standard in cell g3
and the rating in h3