INDEX and MATCH through 2 Sheets.

[xdresch]

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

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

 

[CRHAAG]

I put each of them into a table and used this:

=INDEX(Table2[QTY],MATCH([@SKU],Table2[SKU],0))