Cell Duplicating IF Funtion

[citadel-maritime]

Afternoon Guys,

I need a formula for the below can anyone help,

I need....If cell F3 has something written in it i want G3 to duplicate it, so it says the same thing. If cell F3 is empty I want cell G3 to remain empty.

Thanks

[benishiryo]

hi citadel-maritime, maybe:
=IF(F3="","",F3)

[citadel-maritime]

Thank you Ben, nice to see i have a Forum guru coming to save me,

I have another query on the same formula I hope you might be able to help with.

Column P has a list of entries.

If cell F3 has something written in it i want G3 to duplicate it, so it says the same thing. If cell F3 is empty I want cell G3 to show the last/lowest entry in Column P.

Is this possible.

Thank you for any help you can give.

[benishiryo]

you're very welcome. the guru title is probably obtained due to a minimum post/rep & period in the forum. dont really represent anything

try:
=IF(F3="",LOOKUP(2,1/(P1:P100<>""),P1:P100),F3)
change to range to something bigger if you're expecting more.

[citadel-maritime]

Thank you so much.

[citadel-maritime]

Morning Ben,

I have just sent you a nice thankful massage but I'm not sure if it sent?

I had attached a slight evolution to that formaula if you can help. If possible.....

If cell F3 is empty i want E3 to read the last./lowest entry in column P, if F3 has data in it I want E3 to read the second to last/lowest entry in column P.

Thank you in advance if you can help, as it will get me a raise hehe!

Thanks