IF.... THEN cell EQUALS value from....

[dunmore83]

Hi,

Help on the following would be much appreciated!

If cell L2 is text "Mid R1" then L2 = numerical value from cell H2

If cell L2 is text value "R1" then L2 = numerical value from cell I2

If cell L2 is text value "Mid R1" then L2 = numerical value from cell J2

If cell L2 is text value "Mid R1" then L2 = numerical value from cell K2

Hope you can help!

Cheers

 

[jbeaucaire]

You want a macro to change the actual value in cell L2 to something else? Or is this a formula you want to go in a cell next to L2?

 

[dunmore83]

no its a formula but i now realise i need to add another column

so adjusted now to;

- if J2 = text "Mid R1" then K2 = value from H2

- if J2 = text "R1" then K2 = value from I2

Thanks for your help!!

 

[jbeaucaire]

In K2:

=IF(J2="Mid R1", H2, IF(J2="R1", I2, ""))