changing text in one cell based on the value of another

[jameseldridge]

Hello

I have a report at work where i need to change the value of a cell depends on the value of another to make it more readable to the client.

For example;

Untitled.png

When C1 = idata.o2.co.uk i need to change M1 to say Data - iPhone - Services

I need to do this with a number of other cell values, but rather than do this manually I thought there would be a simple macro to help. Any ideas??

[ragulduy]

in M1:
=IF(C1="idata.o2.co.uk","Data - iPhone - Services","")

[jameseldridge]

Thanks.

I need to do this to multiple different cells at a time and also for other values.

[ragulduy]

What are the other values? you can just drag the formula down/copy and paste into other cells.

[jameseldridge]

Then i may as well do what im doing now which is pretty much the same thing without the formula. i was thinking to run a macro that looks for them values and changes it

[ragulduy]

How does the macro know what values it is looking for and what to change it to?

[jameseldridge]

the values it is looking for are always going to be in column C and the value being changed is always in column M but the values in column C are going to be different and depending on what they are depends on what column M is going to be changed to. So for example i want it to look for cells in column C and if they equal 'idata.o2.co.uk' then i want to change the M column in that row to 'Data - iPhone - Services' i want to do this for different values that are in Column C

[ragulduy]

I meant how does the macro know what values to look for, not where to look for them.

In other words, how does it know what the different values in column C are and what the corresponding values in column M should be.

[jameseldridge]

do you not enter into the code what values to look for and so on?

[ragulduy]

Well you could do the equivalent of the formula I posted:

Please Login or Register  to view this content.

but there is no need to do that with a macro, just write a nested if formula.

I would probably approach this by making a lookup table, but all the possible values of column C in column A on a sheet called "lookup table" and then put the corresponding values for column M in column B on the lookup sheet.
Then your formula in M1 becomes:
=VLOOKUP(C1,'lookup table'!A1:B100,2)
(change b100 to however many values you have)