Hi all
I could not see if this question was asked previously. In my range i want to change only the cell data that is relevant but it wants to override existing data in the column range and show a na where there is no corresponding data. All help is appreciated. Perhaps i need to put something in the formula so it ignores a cell that is not in the lookup table.
Thanks and Merry Christmas
I could not see if this question was asked previously. In my range i want to change only the cell data that is relevant but it wants to override existing data in the column range and show a na where there is no corresponding data. All help is appreciated. Perhaps i need to put something in the formula so it ignores a cell that is not in the lookup table.
Thanks and Merry Christmas