Auto fill

Closed
paulie1307 Posts 1 Registration date Thursday August 13, 2015 Status Member Last seen August 13, 2015 - Aug 13, 2015 at 03:20 PM
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 - Aug 13, 2015 at 05:21 PM
Hello,

im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7.

so "WORD" in cell K7 "WORD" will tell H7 ( )to have the same value as F7(2.50)

thanks
Paul



1 reply

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Aug 13, 2015 at 05:21 PM
Paulie1307, Good afternoon.

Try to use:

H7 --> Formula
=IF(K7="WORD",F7,"")

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0