My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet in almost every case. In addition to that, some the data that we pull from the different source sheets is in fact obtained by a vlookup function. So the chain would be raw data -> vlookup to middle sheet -> vlookup to master sheet.
We have been finding that many of the vlookup functions on sheet in question simply do not work. In all cases, the function syntax is correct. In some cases, the result shows "No Match", which would not make sense because we have triple and quadruple checked the search values on connected sheets to ensure accuracy. In other cases, the first row will pull an accurate data point from the source sheet, but then when we drag the function down, the cells below either come back with a "no match" message or a random number or two are copied over and over again. This is indicated in the right column in the image.
Any ideas as to why this would be happening?
