Hello,
I have a list of cells that need changing to specific numbers in another cell.
I have made this formula: =IF(B8="Chandelier Lighting","63") which puts it into the cell with the formula.
Can I add another formula in the same cell so when i pull down it will automatically assign the cells numbers.
I have attached the file i have been testing on if it helps.
Thanks, Adam.
Bookmarks