When I adjusted the formula to refer to my actual mastersheet, rather than the example sheet, it just had a lot of "0"s and "no match"s.
I can only create solutions for what I am given, not what you are working with IRL.

If you provide samples of the csv and master file that are truly representative of your live data, I’m sure it can be adapted.

though the information was not in the correct columns
You can't replace the search values/columns with the data from the master file without using VBA. Although this thread is in the programming sub-forum, I was trying to avoid VBA, given your stated lack of experience with Excel, let alone VBA.

I added the names from the master file on the end of the row to give you all the detail. That can easily be shuffled around.

My thoughts were to provide a simple (albeit manual) process.

Open the csv file.
Add the formula and copy it down
Save the csv file; this would convert the formulae to values

We can still use that model with a couple of slight tweaks.

Open the csv file
Add the formula and copy down
Manually copy the formulae and paste special values
Delete the two search columns
Save the csv file

Last point: your sample Master file indicated the lookup columns were A:B. If that's not the case, then the formula will not be looking in the right place.