Show cell based on current date

[jimjonesx]

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

 

[hernantorres23]

Hi.
Please, try prepare a data example using add-in specifically for this, it can be found here XL2BB.
Note: If would necessary, pay attention to this post XL2BB 2 Square