Help I Lost

[neilb]

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?

 

[PaddyD]

Sounds like you need to do a multi key lookup - see here for a few examples:

http://www.mrexcel.com/board/viewtopic.php?topic=21288&forum=2

& post back with more details if you need...

Paddy

 

[neilb]

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]

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]

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]

Any takers or am I completely of line?

Neil

 

[PaddyD]

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
	A	B	C	D
1	Plant	NoName	Stock
2	1329	depot1	3
3	2589	depot2	0
4	2619	depot3	0
5	2939	depot4	290
6	4969	depot5	1
7
8
9	Find
10	Plant	NoName
11	2939	depot4
12
13		dget	290
14		index	290
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