how to make formula for this choice

Question

Hello Gents,&nbsp; &nbsp; &nbsp;Good Day to you!&nbsp;I need help to make formula for the below table to be:&nbsp;if i find city view (column J ) came with DBL it equal column C.v&nbsp; DBL from column G which is the view and if it came city view with TPL it equal C.V TPL from column G and i need to repeat it for every line.&nbsp;&nbsp;&nbsp;Thanks and appreciate your help and efforts.

hansvogelaar · Answer

HUSSIENASCANT&nbsp;
Where exactly do you want formulas?

hitman_semsem2007 · Answer

HansVogelaar&nbsp;Thanks for your reply, please find below pic&nbsp;&nbsp;i need it in separate box&nbsp;

hussienascant · Answer

HansVogelaar&nbsp;@HansVogelaar&nbsp;Thanks for your reply, please find below pic&nbsp;&nbsp;i need it in separate box&nbsp;&nbsp;

hansvogelaar · Answer

hitman_semsem2007&nbsp;
How do we know which value to look up?

hitman_semsem2007 · Answer

HansVogelaar&nbsp;&nbsp;Thanks i figured it from your question.

Forum Discussion

how to make formula for this choice

Share

Resources