Forum Discussion
Comparing data & automatic adding of classification
Hi all,
I hope you can help me out here.
The file I'm working has about 5000 rows with various comments. I have to classify these comments in 4 categories and for one category I have to be even more specific. example.
Comment: "Out of time" - means the guy didn't have enough time to deliver a parcel. That would be classified as COI/LMD
Comment: "Weather" - would be OTH (other)
My question now is, is it somehow possible to create something that populates the classification for me, after checking if the comment fits in this spectrum?
like
"=IF(outoftime
then COI/LMD"
I know that would be java, but is it possible to create something like that for xls?
kind regards
Raph
Create a mapping table (shown on the same sheet below but it can be on a different sheet)
Formula in B3:
=XLOOKUP(A3, D$3:D$6, E$3:E$6, "No match", 0)Corresponding sample attached
6 Replies
Create a mapping table (shown on the same sheet below but it can be on a different sheet)
Formula in B3:
=XLOOKUP(A3, D$3:D$6, E$3:E$6, "No match", 0)Corresponding sample attached
- Thanks for the quick turn around! your help is appreciated 😄
You're welcome. Any issue let me know & please upload a dummy representative workbook
Otherwise if problem solved, somewhere on each reply there's a link to mark as Best reponse => Can help those who search - Thanks
