match and copy row data into table

getdata.jpg
Need help creating a macro that will match up the number in AD2 to the numbers in Range AD4:AD50, and place the corresponding data in AE2 alongside it.
These are one-time entry values in the range.
Thanks.

Hi,

If a macro doesn't come along you can use a formula.

In cell AE4 enter this and copy down:

Please Login or Register  to view this content.

Hope this is helpful.

Cheers

The only problem with formula is it keeps updating. I need the entry to go in as a value ( one time entry). The worksheet refreshes every 24 hours.

If AD4:AD50 is sequectial like the picture.

Please Login or Register  to view this content.

Otherwise.

Please Login or Register  to view this content.

Sir, that was amazingly clever! Thank you very much !!!
It fits into the rest of my macro perfectly.
Rob