Joins based on multiple fields

SLouq

I have an excel spreadsheet with Address and Street Name in it and I have a Address feature layer which also has Address and Street Name in it. I want to join the Excel table to the Address feature layer but I want the join to be based on these two fields. 

I tried with a basic Add Join but that doesn't seem to work as some numbers may also be associated with a different street. 

How can I do this?

LindaWilliams1

Can you create a new field in both the spreadsheet and feature layer? I have done a similar join before using a field containing a concatenation of the address number and the first 5 characters of the street name. You could also use the complete street name instead of 5 characters, but in my case I was trying to capture Ave versus Avenue as a match rather than those being different addresses.