How to check if two cells have the same row in excel?

I'm working on a huge file that gets data from a spreadsheet. I need to match the store number and the store name and retu the correct address. This would be easy but a lot of the store numbers repeat, so I can't just match the store number. I also have to match the store name. Sample data:

Store Name         Store Number     Address
Kroger - Dallas    450              123 Street
Kroger - Delta     450              453 Street
Kroger - Atlanta   450              648 Street
HEB                450              349 Street

I already know how to retu the address if the store number matches, but with these stores, their store numbers sometimes conflict with each other. When working with Sam's Clubs, it's easy since no store number conflicts with each other so all the data gets retued wonderfully.

I'm trying to first check if the name contains "Dallas" or "Atlanta", etc. and then check for the store number that related to that name, and retu the address.

This is the formula I'm trying but it says there's an error. Where D3 is the cell that contains the store name and store number.

 =IF(SEARCH("Kroger", $D$3), IF(ROW(SEARCH("Dallas", D3))=ROW(MATCH(INT(RIGHT(D3, LEN(D3)-FIND("#", D3))), B2:B985)), "Match!", "No Match."), IF(RIGHT($D$3,1)="#","Enter a Valid Store Number", INDEX(Locations!$C$2:$C$985,MATCH(INT(RIGHT($D$3,LEN($D$3)-FIND("#",$D$3))),Locations!$B$2:$B$985,0),)))

If I replace the IF(ROW()=ROW()) with this:

IF(ROW(D3)=ROW(D3), "Match!", "No Match.")

It works so I know the error isn't in the rest of the formula.