Looking for a formula

[dannythelearner]

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

Location <tbody> </tbody>	Vehicle No. <tbody> </tbody>	Transport <tbody> </tbody>	Weighment <tbody> </tbody>	Charges <tbody> </tbody>	Total <tbody> </tbody>	Credit <tbody> </tbody>	Profit <tbody> </tbody>
Apple <tbody> </tbody>			240	4100	4340	4540	153
Orange <tbody> </tbody>			110	4500	4610	4910	250
Grape <tbody> </tbody>			110	4600	4710	4910	153

<tbody>
</tbody>

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.