Bonkers Bill
Active Member
- Joined
- Feb 14, 2005
- Messages
- 347
Hello, i should know how to do this by now but i keep getting answers with Vlookup and i need index,
B1-M1 have months of the year, under each month are lists of Takings figures
A2-A30 are suppliers
i need to index(B1:M1, match(AA1 which is the month i want then index(A2:A30,match(Z2 which is the supplier i want to fing the takings figure
i have done these before but i cant for the life of me figure this out, any help apreciated, cheers.
B1-M1 have months of the year, under each month are lists of Takings figures
A2-A30 are suppliers
i need to index(B1:M1, match(AA1 which is the month i want then index(A2:A30,match(Z2 which is the supplier i want to fing the takings figure
i have done these before but i cant for the life of me figure this out, any help apreciated, cheers.