I need to find a value in a table where value in Column A = "example"
and date across Row 1 = "Aug-08". I am summarising data in a simple
table in my first excel sheet and have got a dropdown listbox for the
month, fixed fields for the values in column A.

Table layout is as below:-

A B C D
Aug 08 Sep 08 Oct 08
Utilities 100.00 110.00 120.00
Rent 550.00 550.00 560.00

I understand that in the basic VLOOKUP
(lookup_value,table_array,col_index_num,range_look up) column index
number can be changed so 2 is Aug and 3 is Sep and so on. But I now
need to 'nest' a second lookup to return data from Aug 08 column when
I select Aug-08 in my dropdown.

help!