I am having two tables, one table is main data, separated into many columns and blocks per 10 rows in one, this is fixed. In Column A are unique numbers that will be used in drop down.
Table 1
On second table is a report or printing sheet where I would like to have all infos from table 1 when choosing from drop down list from Column A2. To populate all matches, starting from Column B, no matter if there are couple matches or if it is complete, means there are blanks too, but withing those blocks of 10 rows.
I have been using this formula but I am not getting proper result, or it matches only for first row and rest is or repetative or error.
=INDEX(Table1[Datum];SMALL(IF(Table1[Nummer]=Printable!$A$2;ROW(Table1[Nummer])-ROW(INDEX(Table1[Nummer];1;1))+1);1))
Data added!
Normal vlookup is also starting point but I got lost with everything and simply cant get all required matches..
Number Date Signature 1. Problem 2. Description 3. System
ÄM11_1 01.01.2021 MV Alarm ON Alarm OFF 0528
01.02.2021 AB N/A N/A 0347
10.02.2021 CD Pressuure H! Valve 0321
... this is for one unique number (column A), ten rows are per one block (same as on screenshot divided with line)...doesn't have to be full but must be 10 rows!
Edited! Output should be something like this...colored field is drop down, and when I choose something from it, all fields should be updated with the data from main table...everything at once.