icanspeakwhale
New Member
- Joined
- Nov 7, 2011
- Messages
- 2
I am working on a project for my class. I uploaded the workbook on mediafire 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 ExcelForum.com as well
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 ExcelForum.com as well