Help I Lost

neilb

Board Regular
Joined
Apr 18, 2002
Messages
128
Hi

I have just started receiving a spreadsheet that I need to take data off. My problem is to find the right cell in column F I need to locate it by using 2 numbers in column A. The first number is a product number and the second is a depot number( there is usually 10 depots).There can be 50 of these on one sheet.
My way to get around this is to create a new column and put the product number next to the depot number. Is there a way to do this automatically? or am I going in completely the wrong direction?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

neilb

Board Regular
Joined
Apr 18, 2002
Messages
128
Here is a example of my problem.


103190 Company number
1090 Product number

Total
Physical
Plant NoName Stock
1329 depot 1 3
2589 depot 2 0
2619 depot 3 0
2939 depot 4 290
4969 depot 5 1

All the data I need to use is in column A. How do I search by product number and then depot when all the numbers are in columnA?
 

neilb

Board Regular
Joined
Apr 18, 2002
Messages
128
Here is a example of my problem.


103190 Company number
1090 Product number

Total
Physical
Plant NoName Stock
1329 depot 1 3
2589 depot 2 0
2619 depot 3 0
2939 depot 4 290
4969 depot 5 1

All the data I need to use is in column A. How do I search by product number and then depot when all the numbers are in columnA?
 

neilb

Board Regular
Joined
Apr 18, 2002
Messages
128

ADVERTISEMENT

Here is a example of my problem.


103190 Company number
1090 Product number

Total
Physical
Plant NoName Stock
1329 depot 1 3
2589 depot 2 0
2619 depot 3 0
2939 depot 4 290
4969 depot 5 1

All the data I need to use is in column A. How do I search by product number and then depot when all the numbers are in columnA?
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
It might help if you gave an indication of what you've tried to do to solve this already, whether the link I suggested was appropriate, what problems you had trying to implement the suggesions.

That said, does this help:
Book9
ABCD
1PlantNoNameStock
21329depot13
32589depot20
42619depot30
52939depot4290
64969depot51
7
8
9Find
10PlantNoName
112939depot4
12
13dget290
14index290
15
16
Sheet3



which gives you 2 ways of doing a multikey lookup. If it doesn't help, please give an indiaction of why not. A worked example of your problem, detailing the data you have & the expected outcome would be useful.

Paddy
 

Forum statistics

Threads
1,144,739
Messages
5,726,006
Members
422,652
Latest member
Elnene1

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