viomman
04-29-2010, 07:19 AM
I need an example if anyone has one. This problem spans access and excel.
I have three cells in my excel spread sheet that need to match a look up in the access table and return a value in another collumn. My three cells are like (O5) the series indicator C9(which is the year) and C10(which is the month and quarter like "M01". My access table has a series ID collumn a year collumn a month collumn and a value collumn. I need to look up and match all of the first three collumns based on the refrence cells (O5,C9 and C10) and return the value collumn. Presently the formula in the cell looks like this
{=INDEX(Current1!$A$2:$D$60000,(MATCH(1,(Current1!$A$2:$A$60000=$O11)*(Curr ent1!$B$2:$B$60000=$C$9)*(Current1!$C$2:$C$60000=$C$10),0)),4)}
but the data is getting too big for the lookup worksheet and I must go to a larger data model.
Does any one have an example of this?
Or can any one please help me?
I have three cells in my excel spread sheet that need to match a look up in the access table and return a value in another collumn. My three cells are like (O5) the series indicator C9(which is the year) and C10(which is the month and quarter like "M01". My access table has a series ID collumn a year collumn a month collumn and a value collumn. I need to look up and match all of the first three collumns based on the refrence cells (O5,C9 and C10) and return the value collumn. Presently the formula in the cell looks like this
{=INDEX(Current1!$A$2:$D$60000,(MATCH(1,(Current1!$A$2:$A$60000=$O11)*(Curr ent1!$B$2:$B$60000=$C$9)*(Current1!$C$2:$C$60000=$C$10),0)),4)}
but the data is getting too big for the lookup worksheet and I must go to a larger data model.
Does any one have an example of this?
Or can any one please help me?