Excel / Formula Question! Please help!

[RobBro1987]

hi guys.

please see the photos attached. This is my problem.
On sheet 2, I'd like to enter UPC's in "A" column. And then add a qty in "B" column. (Which is not a problem)

However, I'd like sheet 1 to track the upc's and qty's.

so when I type in a upc and qty on sheet 2, I'd it to match and autofill this information (qty) in the right row and cel on sheet 1.

I hope you guys know what I mean and are able to help me!
Thank you soooo much! I highly appreciate it!

 

[Jambi46n2]

Your pictures didn't come out very well.
Are you able to provide screen shots instead?

 

[Toadstool]

Hi RobBro1987,

Your images are too small to read but I'm guessing you want something like this.

Sheet 2

Book1
	A	B
1	UPC	Quantity
2	CDE	345
3	NPQ	678
Sheet2

Sheet1

Book1
	A	B	C	D	E
1	Can't Read 1	Can't Read 2	Can't Read 3	Guessing UPC	Quantity Here?
2	Mole	Possum	sfsfs	ABC
3	Goat	Raccon	jkl	CDE	345
4	Sheep	Chipmonk	geger	FGH
5	Dog	Owl	vbnvbn	JKM
6	Cat	Deer	yuiiu	NPQ	678
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=IFERROR(INDEX(Sheet2!$B$2:$B$16,MATCH(D2,Sheet2!$A$2:$A$16,0)),"")