Hi
I would like to type/paste the code from table with data and retrieve other codes which match certain conditions.
For example (check the attached picture/xls):
- I want to know if there's another code with exactly the same description and one of the manufacturers as code 0001.
So I copy this code, paste it in other sheet and retrieve list of codes with the same exact desc. and one of the manufacturers.
Exact example with attached xls/img:
I take code 0001, paste it in somewhere, the formula checks if there are other codes with this exact desc. xxx.yyyy.10%.2x5.t_tl and samsung as one of the manufacturers (4 columns with manufacturers, so somewhere in them).
Bing! There is one match! code 0012 has the same desc. as code 0001 and the second manufacturer is the same as in first code.
Potential issues:
- sometimes there's no manufacturer at all, marked as 'na'
- there are following manufacturers' columns without any data (empty)
Bookmarks