Merger index

[parsec]

Here is my Issue.
Sheet1 (with four Columns )
ItemNumber | Name | QtyOnHand | Actualcount

Sheet2 (With two columns)
ItemNumber | Qty

I am using this formula "=INDEX(Sheet2!$B$2:$B$7,MATCH(A2,$A$2:$A$7,0))" to match the ItemNumber on any cell in both of the Sheets and get the value fro Sheet2 ""Oty" into Sheet1 Actualcount
Some how it has become a difficulty for me to make it work.
if possible I like to see how the INDEX/MATCH, or Power Query works
thank you
John

 

[parsec]

Thank you for your time it help a lot

 

[sandy666]

You are welcome