GoogleSheets: Vlookup if divide

Originally Posted by JohnTopley

Try

=IF(ISTEXT(B2),LOOKUP(B2,{"High","Low","Medium"},{9.9,3.33,6.67})/D2,B2/D2)

Thank you, worked now !