Hi!
Having a matrix of four columns (date; store; payment; value), how can I search the cash value for a singular store in a specific day? Does Vlookup works? How?...
Thanks in advance.
Jorge
| Date | Store | Paym | Value | | | | | | |
| 01/jan | A | cash | 57,00 € | | StoreA | 01/jan | 02/jan | 03/jan | 04/jan |
| 01/jan | A | cards | 60,00 € | | Cash | Value? | | | |
| 01/jan | B | cash | 72,00 € | | Cards | | | | |
| 01/jan | B | cards | 61,00 € | | | | | | |
| 01/jan | C | cash | 73,00 € | | | | | | |
| 01/jan | C | cards | 53,00 € | | | | | | |
| 02/jan | A | cash | 65,00 € | | | | | | |
| 02/jan | A | cards | 75,00 € | | | | | | |
| 02/jan | B | cash | 55,00 € | | | | | | |
| 02/jan | B | cards | 87,00 € | | | | | | |
| 02/jan | C | cash | 75,00 € | | | | | | |
| 02/jan | C | cards | 62,00 € | | | | | | |
