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

ID	Other_Data	New_Amount
ABC123		221
DEF456		333
QWE001		25

<tbody>
</tbody>

Sheet8 (Data dump)

ID	Other_Data	Other_Data	New_Amount
abc123			221
DEF456			333
QWE001			25

<tbody>
</tbody>

 

[sheetspread]

The second post here might help:

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