how to find last value in a column, and replace data

Question

Hi,

In the attached file "UH data", I want to go to last date (11/17/2020) and do vlookup of this date with date in "Med" file and copy all data from "Med" after that date. This data (after data 11/17/2020 in this case) will replace existing data in UH data file. Both columns (date and amount) needs to be replaced.

Med.xls

UH data.xlsx

AngelosPachis · Answer

Hi @abagga ,

Would something like this work for you?

I have added the output tool in a container box, but essentially once you activate it it will overwrite the data in the UH input file.

Hope that helps,

Regards,

Angelos

example.yxmd

abagga · Answer

Does it also deletes existing data in UH data completely. I want that to happen

Qiu · Answer

@abagga 
Sorry, seems I did it the other way around.

1223-abagga.yxmd