Hello,
I come for help My situation is very specific and I just can't get match/index functions to work (probably doing something wrong).
Data structure:
Item stock= yesterday's stock - consumption + production + incoming + delivery - modification + "+/-"
=> Throughout the month (year); Some parts of the data are references from another sheets.
I would like to display the current stock for each item (roughly 30~) in another sheet (not necessarily = can double reference) based on current day = that is, without having to modify the current day reference (so far I'm just replacing reference with CTRL+H or just copy pasting the data).
I assume this can be done pretty easily via index/match functions or whatnot... Nevertheless, as I mentioned before, I just can't get it to work. It never finds the value and cell says "#UNAVAILABLE" or something in similar fashion (I have excel with diff language).
Any help would and will be greatly appreaciated.
Thanks a bunch!
Jim
I come for help My situation is very specific and I just can't get match/index functions to work (probably doing something wrong).
Data structure:
Item stock= yesterday's stock - consumption + production + incoming + delivery - modification + "+/-"
=> Throughout the month (year); Some parts of the data are references from another sheets.
I would like to display the current stock for each item (roughly 30~) in another sheet (not necessarily = can double reference) based on current day = that is, without having to modify the current day reference (so far I'm just replacing reference with CTRL+H or just copy pasting the data).
I assume this can be done pretty easily via index/match functions or whatnot... Nevertheless, as I mentioned before, I just can't get it to work. It never finds the value and cell says "#UNAVAILABLE" or something in similar fashion (I have excel with diff language).
Any help would and will be greatly appreaciated.
Thanks a bunch!
Jim