Excel sheet to track defect and autopopulate defect numbers based on the desciprtion

[anandgjha]

Hello,

I have a excel sheet to track down incident. every incident has a defect# assigned to it, i want that the defect number to autopopulate by looking at the incident descption and resolution description .Current i have to manually feed in the defect numbers for each and every incident by looking at the incident description and resolution steps. THe defect number and details are a part of same excel but in a different sheet.

THanks in Advance

AJ.

[ben_hensel]

You could do, like,
this_defect_number = Index(otherSheet!list_of_defect_numbers, Match(this_description, otherSheet!list_of_defect_descriptions, 0) )

But only if you have a table of standard incident descriptions lined up next to their defect numbers, AND people always use that exact description (maybe 'cause it's a dropdown list?).

But if its, like, people are just filling in a description however they want and you have to figure out which it is by using your reading comprehension, then....
That's really hard.

[anandgjha]

hello Ben thanks for the reply did tried that but what i am looking out for is that the defect number get populated by looking at certain words or phrase from the incident description and resolution columns. for e.g. if the incident desciption says system can boot up and the description says Hard disk crashed and need to be replaced and my defect sheet has defect description and defect number for the issue day defect description HDD failed and Defect# 123 so the formula will autopopulate the defect number 123 in the defect number column of the incident tracking sheet.