Hi
Attached is a spreadsheet that I am working on, on the 3050x2030 tab is the data I have imported. I am looking at getting sheet 1 to look at this data and return the correct figures. If you look at cell C25 this returns the correct data. But I then can't figure out how to get the data for the used and weight cells C26 and C27 which is columns E and F on the 3050x2030 tab. I also can't get the formula to work when replicated for other thicknesses see cell C31. I am trying to get a result based on looking up 4 cells Date, shift, thickness and then (either qty,used or weight)
Am I going about this completely the wrong way or am I making a simple mistake?
Bookmarks