Forum Discussion

Copper Contributor

Sep 13, 2022

pourin up

i count it underneath the table to be safe, im pourin up this syrup til my cup is coloured grape

Silver Contributor

Sep 13, 2022

chaserr You need INDEX/MATCH function. Try-

=INDEX($C$2:$C$5,MATCH(E7,$A$2:$A$5,0))/I7

Or XLOOKUP() with O365. See the attached file.

=XLOOKUP(E7,A2:A7,C2:C7,0)/I7