Match text
 

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.

Match text
 

Do

=MATCH(lookup_value,lookup_table,0)

--
__________________________________
HTH

Bob

"L" wrote in message
...

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.