Copy date from a different Sheet

[luisitocarrion1900]

I want to be able to copy data from a different sheet to a specific feel in a another sheet.

I have a sheet named GSO Inventory Stats and a sheet named Retag metrics. I need to put a formula in Column I, that if Column H in sheet GSO Inventory Stats matches the sheet named Retag Metrics Column A move the data from Column D into the Sheet GSO Invenotry Stats Column I.

 

[DanteAmor]

It seems you need the vlookup formula
Put this formula in cel I2 on sheet "GSO Inventory Stats"

=VLOOKUP(H2,'Retag metrics'!A:D,4,0)

 

[luisitocarrion1900]

What about if i want to add also the same as Retag Metrics but also read the same info from the Sheet IRM Inventory Stats

 

[DanteAmor]

Does the formula work for what you asked for in the initial post?
The next thing you ask, you can explain it with examples.

 

[luisitocarrion1900]

Sorry, yes it did

 

[luisitocarrion1900]

I have a question how can it be modify so that if the data is is not found just leave it blank and not add the #N/A

 

[DanteAmor]

Try

=iferror(VLOOKUP(H2,'Retag metrics'!A:D,4,0),"")

 

[luisitocarrion1900]

Thank you so much it worked like a charm

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.