Hi Everyone,
I'm new to the forum and have had a search around but can't find the answer to my problem - apologies if I've missed it, my excel knowledge is not that great so it may be that someone has posted an answer to another query and I just don't realise it solves my issue!
I've attached a small sample of what I'm trying to achieve, I want to pull the amount being produced on a specific product and date through from the "Plan" sheet to the "Bulk" sheet (the formula is in C18 on the attached), the "Plan" sheet will get copied in from another source daily and can't really be altered but I can make any amendments at all to the "Bulk" sheet.
I've currently used this formula:
=INDEX(PLAN!$C$2:$AM$34,MATCH(BULK!$A$18,PLAN!$C$6:$C$31,0),MATCH(BULK!C6,PLAN!$C$2:$AM$2,0))
However, the result been brought back is from row 7 rather then row 11 as I'd expect. When I do this same calculation on my original spreadsheet (not this reduced sample) it brings back the data for the correct row but the incorrect column so I'm obviously doing something wrong but I have no idea what.
Any suggestions would be gratefully received....
Many Thanks
Bookmarks