GoogleSheets: Vlookup if divide

[maniacs205]

Sorry, then I will change my question, please check my updated screenshot and file attached https://prnt.sc/M2-kcsimj4KR.

I want to know the formula, at colomn E2, how to divide B by D and drag down to E5 ?
in a condition, changing the text value to becomes number as following :

low -> 3.33
medium -> 6.67
high -> 9,90

[AliGW]

Which version of Excel is this for? Or does it need to work with Google Sheets?

[TMS]

You can't divide B3 by D3 because B3 has text in it.

[maniacs205]

hi

its for google sheet

[AliGW]

Thread moved to the correct sub-forum.

[maniacs205]

You can't divide B3 by D3 because B3 has text in it.

Sorry, then I will change my question, please check my updated screenshot and file attached https://prnt.sc/M2-kcsimj4KR.
I want to know the formula, at colomn E2, how to divide B by D and drag down to E5 ?
in a condition, changing the text value to becomes number as following :

low -> 3.33
medium -> 6.67
high -> 9,90

[AliGW]

Don't provide links to screenshots - a workbook attached to your post is better, but you can attach a screenshot directly here, too. Nobody should have to follow links.

[maniacs205]

Sure no worries, I made in excel sheet now :

https://docs.google.com/spreadsheets...iJM/edit#gid=0

[JohnTopley]

Try

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

[maniacs205]

Try

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

Thank you, worked now !