Excel Formulars - Access Queries

[Tezdread]

Hi,

Is there any easy way to convert excel formulars into access queries?

Basically there is a spreadsheet that is currently being used, the user enters data into cells 1 - 10 for example then based on these values it will change the value in another table. All sounds straight forward and standard.

The biggest problem I face is in understanding the formular in a way so that it can be changed into a query.

This is an example: (that I don't understand)

=INDEX('Limits allocated'!$B$12:$H$20,MATCH(S8,'Limits allocated'!$A$12:$A$20,0),MATCH(U8,'Limits allocated'!$B$12:$H$12,0))

If it's going to be really complex to complete in a query what alternatives are there? I was thinking that I could use an Unbound Object Frame and just insert the whole spreadsheet but this is far from ideal.

Thanks

Tezdread
"With every solution comes a new problem"

 

[MichaelRed]

Index" in Excel is ~~~ DLookup in Ms. A., The range(s)would correspond to the Domain. Find the Function Dlookup via the ubiquitous {F1} (aka H E L P).





MichaelRed

 

[Tezdread]

Thanks Michael, I might have to use the DLookup as I'm stuggling a bit with the query I'm trying to sort...

Tezdread
"With every solution comes a new problem"