Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Andreea Miluta la Simpatie.ro
 | Femeie
24 ani
Braila
cauta Barbat
30 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 3 luni#1 |
TRaPModerator
Postari: 960
|
|
I know there are multiple solutions for this, and here is one of these solutions below.
What I want is to make a dashboard based on yearly data structured in a specific way (not as tables).
=INDEX(
FILTER(RAW!$D$7:$Y$1000;
(RAW!$A$7:$A$1000=C$3)*
(RAW!$C$7:$C$1000=$B6));
1;
MATCH($B$3;RAW!$D$5:$Y$5;0)
) |
where
$D$7:$Y$1000 - contains the data I want to retrieve
$A$7:$A$1000 - contains year
$C$7:$C$1000 - contains parameter
$D$5:$Y$5 - contains company name |
The FILTER function results in a spill, and the INDEX-MATCH picks the value in the spill corresponding to the company selected in B3.
Source: ChatGPT
Others - untested for the above purpose, but might work:
DOUBLEXLOOKUP - LAMBDA function by Excel off the Grid
SUPERXLOOKUP - LAMBDA function by Excel off the Grid
|
|
| |
|
