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
Bookmarks