Match text

  • Thread starter Thread starter L
  • Start date Start date
L

L

i am using 'match' to do a match text and put into a category. However, the
match is not an exact match, but rather includes all text up until the next
match.

For example:
exact match of 1000 - populates into an apple category
exact match of 2000 - populates into an orange category

What it's doing right now is if there is 1050, it puts it in the apple
category, when I just want it to be NA.
Can someone suggest another function i can use to get an exact match?
Thanks.
 
Back
Top