IF Macro, insert text

[jamessaunders]

I would like to create a macro that changes a content of a cell depending on the value inserted.

For example:

If the value '0570651' is entered into cell A1, I would like cell A2 to contain the text '300mm internal diameter concrete strength Class M..."

If the value '0570652' is entered into cell A1, I would like cell A2 to contain the text '300mm internal diameter concrete strength Class P..."

There are numerous values and descriptions, can anyone help?

Thanks in advance.

[Bryan Hessey]

I would like to create a macro that changes a content of a cell depending on the value inserted.

For example:

If the value '0570651' is entered into cell A1, I would like cell A2 to contain the text '300mm internal diameter concrete strength Class M..."

If the value '0570652' is entered into cell A1, I would like cell A2 to contain the text '300mm internal diameter concrete strength Class P..."

There are numerous values and descriptions, can anyone help?

Thanks in advance.

HI,

On Sheet2 setup in column A the items and in column B their corresponding values

then in Sheet1, in A2 put

=VLookup(A1,Sheet2!A:B,2,False)

It is normal to do this across a row (A1 B1 etc) rather than down a column (A1 A2 etc) but its your choice.

hth
---