Auto fill

[Closed]
Report
Posts
1
Registration date
Thursday August 13, 2015
Status
Member
Last seen
August 13, 2015
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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