Cross reference cell values then copy data between sheets

[mrkambo]

This one is a bit difficult for me to explain, so i included screenshots to help....maybe

I've have to cover some of the data as its personal information

https://imgur.com/cFDqyS8 source<source

<source (separate="" worksheet)

https://imgur.com/jdC0Ii9 destination<destination<destination (separate="" worksheet)


OK, so on the source you see column H, the last 3 characters are 300, i want the time part of the value in cell R to be copied to destination worksheet in column E

Now the tricky part, the destination worksheet has numbers ranging from 101 to 419, however they aren't sequential or go in ascending order

So what i need, is some kind of code which will look at all the values on the destination worksheet column A, and if it matches the last 3 character values in column H on source worksheet, it then copies the time value to the equivalent row in column E, if not it moves to next row

Im not sure if makes sense....

any guidance would be appreciated</destination<destination></source

 

[steve the fish]

Hi. Try this:

=MOD(LOOKUP(2,1/(RIGHT(Source!$H$1:$H$1000,3)=""&A1),Source!$R$1:$R$1000),1)

Alter the ranges as necessary.