dannythelearner
New Member
- Joined
- Jul 27, 2019
- Messages
- 2
Hi, i need a help. I need a formula for the calculation for the below data
<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.
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||
<tbody> </tbody> | 240 | 4100 | 4340 | 4540 | 153 | ||||||||||
<tbody> </tbody> | 110 | 4500 | 4610 | 4910 | 250 | ||||||||||
<tbody> </tbody> | 110 | 4600 | 4710 | 4910 | 153 |
<tbody>
</tbody>
Thanks in advance. Looking forward your reply.