Copy a certain value from a row to a another row when code matches

[ECYOJ]

Hello there expert!

Here comes my problem.

I got here different vessel name with corresponding vessel code and a amount. I needed to put the amount the to corresponding vessel if it matches the vessel code. Please help me. Further explanation are in the attach excel file.

[Richard Buttrey]

Hi,

In G5 copied across and down

Please Login or Register  to view this content.

But can I ask why you don't just enter the amount in the Vessel List Table? What you are doing seems redundant.

[azumi]

Put in G5, and copied down and cross:

=IFERROR(IF(INDEX('VESSEL LIST'!$A$4:$A$43,MATCH($E5,'VESSEL LIST'!$B$4:$B$43,0))=G$4,$F5),"")

[ECYOJ]

Put in G5, and copied down and cross:

=IFERROR(IF(INDEX('VESSEL LIST'!$A$4:$A$43,MATCH($E5,'VESSEL LIST'!$B$4:$B$43,0))=G$4,$F5),"")

Thank You it works really great but is there a possibility to clear / remove if the FALSE result when it didnt match. Thank You

[ECYOJ]

Hi,

In G5 copied across and down

Please Login or Register  to view this content.

But can I ask why you don't just enter the amount in the Vessel List Table? What you are doing seems redundant.

I want to have a code cause i got many vessel and when i do it manually it is very prone to typo error. Thanks

[azumi]

Thank You it works really great but is there a possibility to clear / remove if the FALSE result when it didnt match. Thank You

Don't quite cleat about what you want, if didn't match what results that you want as a results? Is it blanks? or Null?

[ECYOJ]

Don't quite cleat about what you want, if didn't match what results that you want as a results? Is it blanks? or Null?

SOrry if it is unclear. The result that i want when it didnt match is BLANK. Thanks

[azumi]

Formula in post#3, give you blank results if error occurs, does that happen?

[azumi]

Ooops you right, Please check the file, I change the formula

Regards

[Richard Buttrey]

I want to have a code cause i got many vessel and when i do it manually it is very prone to typo error. Thanks

In that case why not simply use VBA to add the function I gave you. i.e. use the same technique but have it done automatically rather than manually. As a general principle always use standard Excel functionality, (even if you get VBA to do it)

Must admit I'm somewhat confused though. You say you want code and reject the formula I gave you but seemingly are happy with the very same formula from azumi. Where's the consistency?