Forum Discussion

Krish89's avatar
Krish89
Helper II
5 years ago

Lookup values based on multiple conditions

Hello, I have an excel file with two sheets called Data and MF. S.NONew :  =IF(OR(D2="#";D2="NULL");C2;D2) CombinedValue: = B2&A2&E2 (concatenation of ID ,IDNew, S.NONew) Rep: = IFERROR...
Need Help
Krish89's avatar
Krish89
Helper II
5 years ago

Hi v-deddai1-msft ,

 

Thanks for your help!!

But here in your calculated column the IF condition is missing(refer my post).

 

Regards,

Krishna.

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Krish89 ,

 

I am sorry that I am not familiar with Excel. If you can explain more about the logic of Rep column , I will write the right formula for it.

 

Best Regards,

Dedmon Dai