Need formula help in preparing dashboard

[vikijain007]

[TABLE="width: 45"]
<tbody>[TR]
[TD]Project
[/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 461"]
<tbody>[TR]
[TD]Task Name
[/TD]
[TD]First Name
[/TD]
[TD]Second Name
[/TD]
[TD]Actual
[/TD]
[/TR]
</tbody>[/TABLE]

There is data in another sheet in Team Data

In Dashboard sheet –
If I select project then all the details related to project should show up in below table. But name should not appear.
[TABLE="width: 461"]
<tbody>[TR]
[TD]Task Name
[/TD]
[TD]First Name
[/TD]
[TD]Second Name
[/TD]
[TD]Actual
[/TD]
[/TR]
</tbody>[/TABLE]

If I select name then all the details related to project should show up in below table. But project should not appear.
If I select name then first name should be blank.

This is there any method or formulas available to make is possible.

 

[SyedUsman]

You cannot have both the formula & the values in a cell. you cannot have it this way.

Instead you may want to use a helper column for your input

 

[FDibbins]

This could probably be done if you have a row above where you want your answers to show, that will contain the data you want to find.
Then, depending if you want to return just 1 row of matching data, or if you have multiple rows to return, you could either use something like INDEX/MATCH or INDEX/SMALL/IF array

 

[Barnez]

can anyone help me with creating a planning board in excel - which will show a dashboard view of orders?

 

[FDibbins]

can anyone help me with creating a planning board in excel - which will show a dashboard view of orders?

I think you need t start your own thread with your question