HI
Need help with using vlookup.
The below sheet has account numbers in column A, Maturity date in Column B and the rest is the closing balances for the respective months for each account.
On another sheet I need to be able to select the account number, maturity date and the respective month end balance. eg. Account 101 Matures in Nov'2006 and the balace is 4,000.
I have tried in vain with vlookup, but now think its impossible.
Any help will be much appreciated.
Thanks in advance.
TABLE Sample.
Need help with using vlookup.
The below sheet has account numbers in column A, Maturity date in Column B and the rest is the closing balances for the respective months for each account.
On another sheet I need to be able to select the account number, maturity date and the respective month end balance. eg. Account 101 Matures in Nov'2006 and the balace is 4,000.
I have tried in vain with vlookup, but now think its impossible.
Any help will be much appreciated.
Thanks in advance.
TABLE Sample.