Scripting Dictionary as a vlookup

[SamPaulRoger]

Hi,

I was wondering if it is possible to create a scripting dictionary that is equivalent to a vlookup for a report that I am trying to create. Basically I have my Sheet1 where I have my list of "ID" then some other data, and the new amount, which is taken from from Sheet8 - a data dump I get every day. I have been using a formula, however, I am trying to improve this process a little more as the data set is several thousand rows, which is time consuming to calculate and recalculate every time a value is changed within the workbook. My objective is to make this a quick and easy data pull where other people do not have to be concerned about formulas. Any help would be greatly appreciated.

Sheet1

[TABLE="width: 150"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Other_Data[/TD]
[TD]New_Amount[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD][/TD]
[TD]221[/TD]
[/TR]
[TR]
[TD]DEF456[/TD]
[TD][/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]QWE001[/TD]
[TD][/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]


Sheet8 (Data dump)

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Other_Data[/TD]
[TD]Other_Data[/TD]
[TD]New_Amount[/TD]
[/TR]
[TR]
[TD]abc123[/TD]
[TD][/TD]
[TD][/TD]
[TD]221[/TD]
[/TR]
[TR]
[TD]DEF456[/TD]
[TD][/TD]
[TD][/TD]
[TD]333[/TD]
[/TR]
[TR]
[TD]QWE001[/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

The second post here might help:

https://www.mrexcel.com/forum/questions-other-languages/1046818-vlookup-vba-code.html