Need Forumlas for extracting from multiple columns/rows

I am working on a project for my class. I tried attaching the workbook that I am using but it says the file is too large so I uploaded it on another source and took screencaps if you don't want to download it.
Uploaded on mediafire

The sheet I am editing is 'SalesData'. Right now, I am having problems with column P and column U.

For column P, I need to extract data from 'MerchandiseData'. I need a formula that will look at L18 and N18 and extract the price from the 'MerchandiseData.'
I'm really not sure the best way to extract this. I assume it must either be either VLOOKUP/HLOOKUP or INDEX/MATCH. I've tried a couple different formulas on my own and none of them work.

For column U, I need to extract the Street Address from 'Customers'. I was able to use a VLOOKUP to get the Store Name for column T (I used =VLOOKUP(C18,Customers!$A$9:$B$62,2,FALSE) ) but I'm not sure how to extract *only* the street address.


Hopefully I'm making myself clear. I've been working on this project for several days now and I'm getting extremely frustrated.
Any help or tips would be much appreciated!

I cross-posted this to MrExcel as well

In P18, try:

Please Login or Register  to view this content.

in U18 try:

Please Login or Register  to view this content.

so then in V18 it would be:

Please Login or Register  to view this content.

and for consistency, you can also use in T18:

Please Login or Register  to view this content.

and in case you're gonna ask...

in W18:

Please Login or Register  to view this content.

in X18:

Please Login or Register  to view this content.

in Y18:

Please Login or Register  to view this content.

in Q18, I think:

Please Login or Register  to view this content.

in R18, I think:

Please Login or Register  to view this content.

each of these formulas copied down.