please help me with a formula which work like nested if,
requirement
I have a digit like "18964" - if look up matches the value needs to be updated in column if not match then using MID look up for "1896"(cutting last digit)if not matches using MID look up for "189" if not matches using MID look up for "18"
requirement
I have a digit like "18964" - if look up matches the value needs to be updated in column if not match then using MID look up for "1896"(cutting last digit)if not matches using MID look up for "189" if not matches using MID look up for "18"