Looking for a formula

[dannythelearner]

Hi, i need a help. I need a formula for the calculation for the below data

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="class: xl65, width: 67"]Location[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 76"]
<tbody>[TR]
[TD="class: xl65, width: 76"]Vehicle No.[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD="class: xl65, width: 104"]Transport [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl65, width: 81"]Weighment[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl65, width: 65"]Charges[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl65, width: 65"]Total[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="class: xl65, width: 67"]Credit[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="class: xl65, width: 67"]Profit[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="width: 67"]Apple[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]240
[/TD]
[TD]4100
[/TD]
[TD]4340[/TD]
[TD]4540[/TD]
[TD]153[/TD]
[/TR]
[TR]
[TD]

<tbody>
[TD="width: 67"]Orange[/TD]

</tbody>

[/TD]
[TD][/TD]
[TD][/TD]
[TD]110[/TD]
[TD]4500[/TD]
[TD]4610[/TD]
[TD]4910[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD][TABLE="width: 67"]
<tbody>[TR]
[TD="width: 67"]Grape[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD]110
[/TD]
[TD]4600[/TD]
[TD]4710[/TD]
[TD]4910[/TD]
[TD]153[/TD]
[/TR]
</tbody>[/TABLE]
Row 1 is title, If i type Apple in Row2 under the column1 (Location) it automatically fill rest of the columns from Vehicle no. to profit(with given data s shown in above table). Similar to Orange and Grape if i type orange and Grape it need to automatically fill the respective rows details from vehicle no. to profit columns.

Thanks in advance. Looking forward your reply.

 

[sykes]

Hi, and welcome to Mr. Excel.
This looks like either homework, or an assignment - which should be carried out by the individual.

Neither columns 2 nor 3 can be filled without more data being available.
"Total" column appears to be a simple "Sum" formula of cols 4&5.
"Profit" column is (presumably) Credit minus Total columns, but your data suggests otherwise, as it's inconsistent...

 

[dannythelearner]

Ok, i want if i apple in column location, this things need to automatically comes on following columns weighment is 240, charges 4100, Total 4340. Any idea.