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.

 

[Fluff]

How about
=INDEX('Inventory Stats'!$H$2:$H$100,MATCH(D2,'Inventory Stats'!$D$2:$D$100,0))

 

[luisitocarrion1900]

Not working

 

[Fluff]

In what way?

 

[luisitocarrion1900]

I want to place the formula in Column H7 in the sheet named NEA Status

If the Data in Column D from the sheet NEA Status and the sheet Inventory Stats matches move the information thats on the sheet Column H to the Sheet NEA Status column H

all the data in both sheets start in row 7

 

[Fluff]

That's what the formula does, can you please explain what you mean by "Not working"
Do you get an error, wrong values, or what?

 

[luisitocarrion1900]

When I place the formula in NEA Status H8 it just shows the formula text (=INDEX('Inventory Stats'!$H$2:$H$100,MATCH(D2,'Inventory Stats'!$D$2:$D$100,0))) not the information thats in the Shee named Inventory Stats

 

[Fluff]

In that case make sure the cell is formatted as "General", not "Text" & enter the formula again. Also check that "Show Formulas" on the formula tab is not selected.

 

[luisitocarrion1900]

Now it works what about if there no data just show blank because is showing #N/A

 

[Fluff]

How about
=IFERROR(INDEX('Inventory Stats'!$H$2:$H$100,MATCH(D2,'Inventory Stats'!$D$2:$D$100,0)),"")