Copy a row if it matches a data from the left most column

Hi,

I am trying to copy values and dates from a row if it matches the numbers in the left column.
I attached a simplied version where I explained how it should be done.
Can you please help me with that?

put:
=IF(ISERROR(VLOOKUP($A14,$B$2:$D$9,COLUMN(A$1),0)),"",VLOOKUP($A14,$B$2:$D$9,COLUMN(A$1),0))
in B14 and copy down/across

Hi,

Thanks for your effort.
Can you please attach the file? I am using Excel 2010, so a bit confuse how to modify your code to my file attached.
I am sorry for the pain, and thanks for your help.

Regards

File is attached

Originally Posted by ragulduy

File is attached

Excellent!
Thank you so much for the help.

Hi again,

It seems I still have some issue on this function to implement on my file (please find attached). It works with the simplified example that I sent you in my previous attachment, but it doesn't seem to give rational result in this file attached with this mail.

Can you please have a look in to that (sheet 3 of the file)?

The formula in E209 should become:
=IF(ISERROR(VLOOKUP($D209,$E$4:$H$203,COLUMN(A3),0)),"",VLOOKUP($D209,$E$4:$H$203,COLUMN(A3),0))
then copy down across
(column(A3) is to return 1, which is the column from the E4:H203 range to return the lookup value from, the column(A3) is so that this changes to 2, 3, 4 etc. as it is dragged across but it should always be 1 for the first result.

Hi there!

Still confused. Is it possible to attach the file please?
Thanks for the help.
Regards

File is attached.

Thank you!!