Thread: IF-ELSE Question

Hi,

I am facing a problem on the following:

I have data set on 3 Cost parameter (Energy, Network, Opex) across 11 circles. I am picking the data using vlookup for all circles. But at Infra Level, I have to either pick the value available in data set or calculate the sum of all circles.

In the sample data attached:

If Data for INFRA is available in data tab, pick the values else do the sum of all circles. Answer for Network Infra is 17915.

Therefore, for network and Opex field, it would be sum of all circles and for energy it would be 15000 from data tab.

Please resolve.

Thanks in advance.