I want to have a simple star rating system that a user can select the number of stars, and then this information will be used to calculate a total score.
I have a list of stars, and an associated value with each:
|Location Rating (I16)||Symbol (J16)||Weighted (K16)|
I then have a cell
E3 where the user enters the location rating. It has data validation that it must be an item from list in:
The score for this location is then used using a lookup table:
=LOOKUP(E3, 'Flat Scoring'!J17:J26,'Flat Scoring'!K17:K26)
However, if for example I select 3 stars in
E3, I get the error "Did not find value
★★★ in LOOKUP evaluation."
I think this is because the LOOKUP function does not work with Unicode characters.
Is there a workaround for this bug, or another way to achieve what I want?
edit: My assumption that the bug is due to Unicode may be wrong. Even if I select the "1/2" it still fails.