I need to compare two columns and match like entries up in the same row

I have two excel reports. Firstly, an accounts receivable report with a column of customer names and columns with terms such as "Current", 1-30, 30-60, etc. Secondly, I have a sheet with a column of customer names with a second column of their "average days to pay"

I would like to have these two sheets to compare the customer names so that a particular customer's average days to pay lines up with their accounts receivable information.

My ultimate goal is to have an accounts receivable report that will tell me when we can expect a customer's AR to come in.

I have the sheets available.
HCCI Average Days To Pay.xlsx
HCCI AR.xlsx

Thanks in advance!

Chris Bertolini
Newland, NC

In T2 of the AR sheet put the following formula then drag down:
=VLOOKUP(B2,'[HCCI Average Days To Pay.xlsx]Sheet1'!$B$2:$C$329,2,TRUE)

(now this assumes both are open, you may need to reference filepaths etc if not)