>> Automate Multiple Cells

[GreenBolt]

Hi all,

I'm trying to automate a cell if possible. Your assistance will be appreciated.

* Cell C3 can either have a value of M or F
* If C3 equals M then get cell J20 value and insert in cell E2
* If C3 equals F then get cell L20 value and insert in cell E2


cheers - Greenbolt

 

[Fluff]

How about
=IF(C3="M",J20,L20)

 

[GreenBolt]

How about
=IF(C3="M",J20,L20)

Legend - that worked.

thank you very, very much

cheers - Greenbolt

 

[Fluff]

You're welcome & thanks for the feedback