how to make formula for this choice

Copper Contributor

Hello Gents,     Good Day to you!

 

I need help to make formula for the below table to be:

 

if i find city view (column J ) came with DBL it equal column C.v  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.

 

Screenshot 2024-08-31 181914.png

 

 

Thanks and appreciate your help and efforts.

5 Replies

@HUSSIENASCANT 

Where exactly do you want formulas?

@HansVogelaar Thanks for your reply, please find below pic 

 i need it in separate box

hitman_semsem2007_0-1725119867644.png

 

@HansVogelaar 

@HansVogelaar Thanks for your reply, please find below pic 

 i need it in separate box

HUSSIENASCANT_0-1725121454044.png

 

 

@hitman_semsem2007 

How do we know which value to look up?

@HansVogelaar 

 

Thanks i figured it from your question.