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!
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!
I believe this should do the trick.