Need Forumlas for extracting from multiple columns/rows

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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
...
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.' ...

P18:
Rich (BB code):
=LOOKUP(9.99999999999999E+307,
  SEARCH(MerchandiseData!$A$51:$A$58,L18),
  INDEX(MerchandiseData!$B$51:$D$57,0,
   MATCH(N18,MerchandiseData!$B$50:$D$50,0)))
 
Last edited:

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
...
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...

U18:
Rich (BB code):
=INDEX(Customers!$B$9:$B$62,MATCH(C18,Customers!$A$9:$A$62,0)+1)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,258
Messages
5,600,564
Members
414,389
Latest member
MarkElla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top