We are looking to create a dictionary that does the following:
Replacement Value Value to Match On
Annual Under $250
Mid-Level $250 to $2,499
We are self hosted, so API code would be an option too, but we'd need very clear instructions. Thank you!
I believe this should do the trick.
Something seems to be not quite right. Could you take a look at this file and see what we might be missing?
I think we figured it out. We had a . rather than a comma in the first entry. Never mind!
Cell B2 needs to be a comma, not a period. The first two lines of the dictionary remove commas and also decimal and cents if they are there.
Edited: Oops I didn't see your reply when I put mine in. Glad you got it straightened out!