DavidMWright
New Member
- Joined
- Jul 9, 2018
- Messages
- 5
Good day,
I am hoping somebody can help me.
I have 2 tabs, as shown below. I am trying to copy column C (Name) from tab2 to column C (Name) on tab1 where columns A (ID) match.
Now the above I can do using a vlookup but where I am failing is that it needs to copy the value from the row where column B (Date) on tab2 is the nearest date (same date or in future) of column B (Date) on tab1.
Tab1
<tbody>
</tbody>
Tab2
<tbody>
</tbody>
Hope that makes sense.
Greatly appreciate any help.
Dave
I am hoping somebody can help me.
I have 2 tabs, as shown below. I am trying to copy column C (Name) from tab2 to column C (Name) on tab1 where columns A (ID) match.
Now the above I can do using a vlookup but where I am failing is that it needs to copy the value from the row where column B (Date) on tab2 is the nearest date (same date or in future) of column B (Date) on tab1.
Tab1
<tbody> </tbody> | Date | Name | ||
<tbody> </tbody> |
<tbody> </tbody> | |||
001A000000GISTtIAP |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Tab2
ID | Date | Name | ||
<tbody> </tbody> |
<tbody> </tbody> | Adam | ||
<tbody> </tbody> |
<tbody> </tbody> | John | ||
<tbody> </tbody> |
<tbody> </tbody> | Dave | ||
<tbody> </tbody> |
<tbody> </tbody> | Steve | ||
<tbody> </tbody> |
<tbody> </tbody> | Michael |
<tbody>
</tbody>
Hope that makes sense.
Greatly appreciate any help.
Dave