Hi
I need to compare stock spreadsheets. The problem I have is that I need to check that a row with 6 columns of data is in the main stock list and all cells match exactly what is on a single row in that main stock list.
However, none of the contents of the cells in the row are unique in the main stock list (e.g. there may be 20 occurrences of cell 1 on the list, 12 of cell 2, 16 of cell 3, etc) so a simple vlookup of each cell would not work.
Attached is a small example of what I mean. In reality, the actual stock list has around 800 rows of data across 14 columns, although I only need to use 6 cells to identify it.
Please could anybody point me in the right direction?
Also, would it be possible to find the row if some of the data does not match (i.e. stock taking!) and highlight what doesn't match?
TIA for anybody that can help me
Bookmarks