If statement problem

Originally Posted by Marcol

Is nesting the ifs what you need?

=IF(L2592="A",'Master Factors'!$C$6,IF(L2592="B",'Master Factors'!$C$8,IF(L2592="C",'Master Factors'!$C$10,IF(L2592="D",'Master Factors'!$C$12,0))))

Copy each formula into the previous replacing the false condition,(0), each time.

Thank you perfect solution!

Hi all,


There is a sheet. there are some duplicate values in it. so i want to make those duplicate values unique by adding ( _ and the number) like frag_458830 then frag_458830_1 and so on.
kindly help me.