Retrieving data based on more than 1 criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Thanks Carlo & T.Valko this is great!

T. Valko said:
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)
Click to expand...
 
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...STAT3....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
 
Back
Top