Searching for data based on a set list in select rows.
Posted on 2014-02-07
Column A is the line number - left most digit.
Column B contains a list of part numbers
Column D contains a list of part numbers to be matched up to those numbers in column B
When those numbers in D match up with numbers in B, that cell in D turns green.
Would it be possible to ask "enter line number" so the search and comparing only looks at those line numbers (rows)
Thanks for any suggestions.
Column A :
List of part numbers