With Excel 2016 you have Power Query (aka Get & Transform Data) built in. All you'll need to do is to update the table on the left with your few hundred rows of data, then right-click somewhere in the table on the right and choose Refresh.
As to a formula for column E, quite difficult, but maybe possible with a slightly different Power Query query. I'll have a think on it.
|