CODEWITHSUNDEEP
excelmatrix
Matt Backslash
Matt Backslash

Reputation: 804

Excel, get data from matrix

I have a matrix table in excel, from which I need to get data, with two parameters.

Here's my matrix table: Matrix Table

Now, I want to enter manually Parameter 1 and Parameter 2 as numbers in two fields: Choose parameters

With the values 900 and 2000 it should get the number 283 from the matrix.

How can I do that? I tried at least 5 different variations (german excel) with INDEX and VERGLEICH (MATCH), or with SVERWEIS (VLOOKUP) with VERGLEICH (MATCH).

Here's my latest one:

 =SVERWEIS(B55;'table_2'!B41:AO41;VERGLEICH(C55;'table_2'!A5:A40;0);FALSCH)

In this code, B55 is Parameter 1 and C55 is Parameter 2.

Upvotes: 1

Views: 525

Answers (1)

bzimor
bzimor

Reputation: 1628

Use this formula:

=SVERWEIS(C55;'table_2'!A5:AO40;VERGLEICH(B55;'table_2'!B41:AO41;0)+1;FALSCH)

Upvotes: 1

Related Questions