I am having a complete mental shutdown right now. Basically I'm trying to get match&index to look at sheet 1's SKU and match with Sheet 2's SKU to display the QTY from sheet 2, int Sheet 1's (DISPLAY Column)
I got it to work using only 1 sheet with the formula =INDEX('magento inv'!$E:$E,MATCH(D2,'magento inv'!$C:$C,0)) however after trying to use 2 separate sheets, it simply doesn't work.
sheet 1
sheet 2
I got it to work using only 1 sheet with the formula =INDEX('magento inv'!$E:$E,MATCH(D2,'magento inv'!$C:$C,0)) however after trying to use 2 separate sheets, it simply doesn't work.
sheet 1
SKU | QTY | DISPLAY (FORMULA GOES HERE) |
4543112007414 | 1 | |
4543112017871 | 1 | |
4543112039088 | 2 | |
4543112060426 | 1 | |
4543112070166 | 3 |
sheet 2
SKU | QTY |
4543112007414 | 1020 |
4543112017871 | 1203 |
4543112039088 | 1500 |
4543112060426 | 1000 |
4543112070166 | 1025 |