Updating Cells

[garry240868]

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

[stanleydgromjr]

garry240868,

Welcome to the Excel Forum.

Try:

In cell B1 enter:
=IF(A1="","","orange")

In cell C1 enter:
=IF(A1="","",1)

Format cell C1 for your currency.

In cell A1 enter:
12345

[garry240868]

Thanks just the trick, sorry just one last question I,ve attached the sheet with the source data on is there any way it will recognise different values, for instance if I enter any of the part numbers on the list in A1the cell will update as necessary in B2 & B3 Thanks again

[stanleydgromjr]

garry240868,

if I enter any of the part numbers on the list in A1the cell will update as necessary in B2 & B3

If I enter in cell A1:
1444CZ

What should go in cell B2 and B3?

[garry240868]

Thanks Stan: A1 should be the part number,B1 Description, C1 Qty, D1 Price. Thanks again Garry

[stanleydgromjr]

garry240868,

See the attached workbook "Source Data(1).xlsx".

There are VLOOKUP formulae in cells B1, C1, and D1.

Manually enter/change cell A1.

[garry240868]

brilliant thanks again