Can anyone tell me how to get excel to update different cells with different values? i.e if I enter a number in cell A1 for example OR then B1 will ay for example orange C1 will say £1.00 Thanks any help would be appreciated