Auto fill

Closed
Report
Posts
1
Registration date
Thursday August 13, 2015
Status
Member
Last seen
August 13, 2015
-
Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
-
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

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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