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