Copy Data From Sheets

[luisitocarrion1900]

I have a Sheet Named NEA Status and a sheet Named Inventory Stats

I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.

 

[luisitocarrion1900]

Sorry just notice that some of the data are also in a sheet name IRM Inventory Stats

 

[Fluff]

In that case try
=IFERROR(INDEX('Inventory Stats'!$H$2:$H$100,MATCH(D2,'Inventory Stats'!$D$2:$D$100,0)),IFERROR(INDEX('IRM Inventory Stats'!$H$2:$H$100,MATCH(D2,'IRM Inventory Stats'!$D$2:$D$100,0)),""))

 

[luisitocarrion1900]

It works but now if there no data is showing 0 i want to show blank nothing

 

[Fluff]

Any other requirements, that you have not already mentioned?

 

[luisitocarrion1900]

No other requirement, juts that if blank it dont need to show anything and its showing 0

 

[Fluff]

In that case try
=IF(IFERROR(INDEX('Inventory Stats'!$H$2:$H$99,MATCH(D2,'Inventory Stats'!$D$2:$D$99,0)),IFERROR(INDEX('IRM Inventory Stats'!$H$2:$H$100,MATCH(D2,'IRM Inventory Stats'!$D$2:$D$100,0)),""))=0,"",IFERROR(INDEX('Inventory Stats'!$H$2:$H$99,MATCH(D2,'Inventory Stats'!$D$2:$D$99,0)),IFERROR(INDEX('IRM Inventory Stats'!$H$2:$H$100,MATCH(D2,'IRM Inventory Stats'!$D$2:$D$100,0)),"")))

 

[luisitocarrion1900]

Now is reading that if the Data in H2 Matched the Data in D2 can it be change to read if the Data anywere in H matches the Data in D

 

[Fluff]

It's not matching the data in col H. It's matching the data in D2 to the data in col D on the other sheet.