excel VBA Macro

Dear,
I need a VBA coding to create a formula like a VlookUP/Hlookup for the web to read Json data or csv data like this project :
https://github.com/VBA-tools/VBA-JSON

1/ url cell request to json/csv eg :
https://eodhistoricaldata.com/api/historical-market-cap/AAPL.US?api_token=

2/ the matching data : Date

3/ the value to look for value :
0: {
date: "2017-05-26",
value: 800897962400
},
1: {
date: "2017-06-02",
value: 810491428000
},

4 the array of cell to land those data : A1: A30 or A1:Z1

regards,
Jean-Charles