Filemaker Equivalent to Excel's "Index" function

[mkadam68]

I've tried searching for prior posts on this subject, but got little to nowhere. I'm not even sure of the langauge/vocabulary to use to search. Feel free to point me in a correct direction.

In my Excel spreadsheet, I use the 'Index' function to lookup data from a 'Standards' sheet. The data on this sheet is arranged in a table with columns & rows. 'Index' allows me to specify which cell to lookup the data from, according to the column & row.

I'm trying to do the same with FMP. I want to lookup the specific value from this 'Standards' table. The data in this table is arranged in columns (according to each test result) and rows (according to the Records). I need a way to specify which cell to import the data from, according to row name (record) and column name (field).

Any ideas? (Should I post the FMP file to take a look at exactly what I'm talking about?)

[Raybaudi]

Try to give a look at the GetNthRecord ( ) function

[comment]

In Filemaker, you'd usually look up a value from a related record in another table - and that table would hold a separate record for each value. If there are two parameters to match, then the relationship would use two pairs of matchfields.

[mkadam68]

Try to give a look at the GetNthRecord ( ) function

This seems to be exactly what I was looking for. I've tried it now, but am getting very inconsistent results. It also seems to never show the correct data it should. I've searched Google and don't have any ideas. Suggestions?