Hello,

I have the following problem:
I have a table with data, where not always all cells shall be used, however the sequence must stay the same.
example:

Column 1 Column 2 Column 3 Column 4
x TBA 50 99
DTBP 230 99
x Azeton 50 99

In the first column a x decides if the values of the following Cells need to be used or not. Off Course the x can be in all lines or in none.
I need a virtual data matrix, which includes only marked cells and from which I can extract with VLOOKUP() or Similar the data of the activated cells.
The Matrix should only exist virtually in the formula and have the following form in the example given above

Column 1 Column 2 Column 3
TBA 50 99
Azeton 50 99

From this matrix I want to extract all data linewise.


Can anyone help me?

Thanks

Tommy7571