Vlookup and Match combination
 

If I have months across the top and balance sheet items down the side and I
want to reference lets say Cash (A4) for Aug (column 7) this month but switch
next Sep (column 8), I know that i can nest these two functions but it is not
working properly. Can anyone help?

Vlookup and Match combination
 

Hi

Supposing your data is on Sheet1 and you have Months in B1:M1 and Items in
A2:A100.
On Sheet2 you have items in A2:A100 and you enter a Month in B1
the formula in B2 will be
=INDEX(Sheet1!A$1:$M$100,
MATCH($A2,Sheet!$A$1:$A$100,0),MATCH($B$1,Sheet1!$ B$1:$M$1,0))
Copy down column B as far as required
--
Regards
Roger Govier

"ksal" wrote in message
...
If I have months across the top and balance sheet items down the side and
I
want to reference lets say Cash (A4) for Aug (column 7) this month but
switch
next Sep (column 8), I know that i can nest these two functions but it is
not
working properly. Can anyone help?


__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________

The message was checked by ESET Smart Security.

http://www.eset.com