makeitpossibe
New Member
Hello,
Dear Friends and Excel experts.
I need some help to make an easy formula on excel.
It`s Yoga class activities Students are very in each class highest are 80 in one class.
Excel example has been attached.
(Note: Row- A,F,G,H– don’t worry about these rows. They are just for understandings. The main
Rows are- B-C-D and Rows J-K-L where I need your help)
Row A – Students name
Row B- Roll number of those students which is (predefined)
Row C- Name OR Number of Yoga Asana activities (Example multi asana Mayurasan number given 1, Vajrasan number given 2)
Row D- Yoga Activities Performance Result (Manual Feeding -Result)
Row number F-G-H (just for understanding in details)
Row J-K-L here I need an answer need your help- formula
This is every third or fifth days work
So, What I need is
Once I finished creating a Rows for Yoga Asana Activities (D), Roll number (E) and
Manual result feeding (F)
I want to find an answer look from Row B-C-D and give answer / result in Row J-K-L
Once I type/write any number in Row-J & K it will find an answer for Row-L
Row Number J and K will look/find in to Row B-C & D and give an answer result for Row-L
I need some simple and easy formula. So, incase if I have to do any changes or correction I can do it easily.
Thank you.
Dear Friends and Excel experts.
I need some help to make an easy formula on excel.
It`s Yoga class activities Students are very in each class highest are 80 in one class.
Excel example has been attached.
(Note: Row- A,F,G,H– don’t worry about these rows. They are just for understandings. The main
Rows are- B-C-D and Rows J-K-L where I need your help)
Row A – Students name
Row B- Roll number of those students which is (predefined)
Row C- Name OR Number of Yoga Asana activities (Example multi asana Mayurasan number given 1, Vajrasan number given 2)
Row D- Yoga Activities Performance Result (Manual Feeding -Result)
Row number F-G-H (just for understanding in details)
Row J-K-L here I need an answer need your help- formula
This is every third or fifth days work
So, What I need is
Once I finished creating a Rows for Yoga Asana Activities (D), Roll number (E) and
Manual result feeding (F)
I want to find an answer look from Row B-C-D and give answer / result in Row J-K-L
Once I type/write any number in Row-J & K it will find an answer for Row-L
Row Number J and K will look/find in to Row B-C & D and give an answer result for Row-L
I need some simple and easy formula. So, incase if I have to do any changes or correction I can do it easily.
Thank you.