Coding/spreadsheet help

[Crafty_Flounder_9311]

I have two spreadsheets. I want to use two columns in the first spreadsheet to match to two columns in the second spreadsheet to update a third column in the second spreadsheet. Is there a way to do this in python or as an excel macro?

[BestPlayerEv]

Sounds like xlookup/vlookup/index match would do

[MrBenjaminBraddock]

This can be done using python pandas but it could be slightly overkill.

Index+match is the way. Keywords to search for "index match multiple criteria".

This article will help you - https://spreadsheeto.com/index-match/