[users] Re: Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

[Joe Smith]

Andis wrote:

I'm looking if there is easy possibility to chose variable from the table, like in example below, ...

Maybe something like this:
=INDEX(RegData; MATCH(Height;RegHeights;1); MATCH(Species;RegSpecies;0))

The first MATCH produces the row number; the second the column.

<Joe


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]