hi,
in sheet1 I have source table:
<tbody>
</tbody>Then in sheet2 in A1 I will be selecting car name (Audi, BMW etc).
Now if I choose "Audi" I want to in sheet2 in table display all data contains information about audi.
Column "CAR" will be contains ONLY uniqe names (audi, fiat will occur only once).
Example:
A1 = Audi
<tbody>
</tbody>
Do you know what formula I should use ? You can just help me with one (like how to display year). I know that I can you vlookup, but is other way?
in sheet1 I have source table:
Car | Year | Color | Type |
Audi | 2000 | Red | Sport |
BMW | 2001 | Black | Coupe |
Volvo | 1998 | Yellow | Combi |
VW | 1996 | Black | - |
Fiat | 2003 | Red | Family |
<tbody>
</tbody>
Now if I choose "Audi" I want to in sheet2 in table display all data contains information about audi.
Column "CAR" will be contains ONLY uniqe names (audi, fiat will occur only once).
Example:
A1 = Audi
Audi | 2000 | Red | Sport |
<tbody>
</tbody>
Do you know what formula I should use ? You can just help me with one (like how to display year). I know that I can you vlookup, but is other way?