Retrieving data based on more than 1 criteria
 

Have the following data set and need to find say, the retrieve the number for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Retrieving data based on more than 1 criteria
 

maybe this helps (found with google)
http://www.ozgrid.com/News/ExcelLook...ashListBox.htm

hth

Carlo

"TP" wrote:

Have the following data set and need to find say, the retrieve the number for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Retrieving data based on more than 1 criteria
 

I'm assuming your table looks like this:

.........A........B........C........D...
1..............VIC...QLD...NSW
2...2007....10......20........30
3...2008....5........12........15
4...2009....50......40........30

One way:

A10 = 2007
B10 = VIC

=VLOOKUP(A10,A1:D4,MATCH(B10,A1:D1,0),0)


--
Biff
Microsoft Excel MVP


"TP" wrote in message
...
Have the following data set and need to find say, the retrieve the number
for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Retrieving data based on more than 1 criteria
 

Thanks Carlo & T.Valko this is great!

"T. Valko" wrote:

I'm assuming your table looks like this:

.........A........B........C........D...
1..............VIC...QLD...NSW
2...2007....10......20........30
3...2008....5........12........15
4...2009....50......40........30

One way:

A10 = 2007
B10 = VIC

=VLOOKUP(A10,A1:D4,MATCH(B10,A1:D1,0),0)


--
Biff
Microsoft Excel MVP


"TP" wrote in message
...
Have the following data set and need to find say, the retrieve the number
for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Retrieving data based on more than 1 criteria
 

You're welcome!

--
Biff
Microsoft Excel MVP


"TP" wrote in message
...
Thanks Carlo & T.Valko this is great!

"T. Valko" wrote:

I'm assuming your table looks like this:

.........A........B........C........D...
1..............VIC...QLD...NSW
2...2007....10......20........30
3...2008....5........12........15
4...2009....50......40........30

One way:

A10 = 2007
B10 = VIC

=VLOOKUP(A10,A1:D4,MATCH(B10,A1:D1,0),0)


--
Biff
Microsoft Excel MVP


"TP" wrote in message
...
Have the following data set and need to find say, the retrieve the
number
for
say, VIC 2007, is there an easy formula method? thanks, tony

VIC QLD NSW
2007 10 20 30
2008 5 12 15
2009 50 40 30

Retrieving data based on more than 1 criteria
 

Hi all,
I have a few question about processing data in excel, but I got no
idea how to use VLOOKUP function to solve this,
here is the example :
I got this data

DATES...QTY1....STAT1...QTY2....STAT2...QTY3...STA T3....QTY4....STAT4...QTY5....STAT5
---------------------------------------------------------------------------------------
3.......1.......A.......1.......B.......1.......C. .......
1......D.......1........E
5.......2.......F.......1.......G.......
0................0..............0........
7.......2.......A.......1.......C.......3.......D. .......
0..............0........

zero value on QTY always have null value on STAT

I need the result like this,

.......DATES.........1.......2.......3.......4.... ...5.......6.......7
------------------------------------------------------------------------
A...................0.......0.......1.......0..... ..0.......0.......2
B...................0.......0.......1.......0..... ..0.......0.......0
C...................0.......0.......1.......0..... ..0.......0.......1
D...................0.......0.......1.......0..... ..0.......0.......3
E...................0.......0.......1.......0..... ..0.......0.......0
F...................0.......0.......0.......0..... ..2.......0.......0
G...................0.......0.......0.......0..... ..1.......0.......0

can somebody give me the idea how to use VLookup function to process
the data ?
sorry for my bad english

Thank You
gemes