value in a field that depends on values ​​in other fields

Hello,

I apologize, pls move it to the right forum. I didn't see its for outlook, i go for function problem in title.

My problem : )

In fields B3-M3 i enter numbers. Not at once, at the end of the month.
For example;
at the end of the second month, B3 and C3 would have numbers and D3-M3 would be empty.
Field A3 should populate depending on if fields B3-M3 are populated.
It is fixed value depending in which month we are. So if there is a value in the month, then A3 should change(no matter which value is in B3-M3, any value)
For example
if we are in 1 month i would enter some value in B3 then A3 should change to (for example) 1
if we are in 2 month B3 and C3 would be populated and A3 should change to (for example) 2
and so on...

A3 have fixed value for every month.

Thx in advance

Welcome to the forum.

You have posted in the Outlook section. I presume you meant to post in the Excel section, so I am moving your thread.

Do you mean this in A3?

=LOOKUP(2,1/(B3:M3<>""),B3:M3)

You may need to change commas to semi-colons for your Croatian locale.

I thought it was this:

=IFERROR(LOOKUP(2,1/(B3:M3<>""),B2:M2),"")

Don't think so - (s)he seems to imply (as I read it) that it is the value that needs to be returned, not the month number.

Ding, ding, … I think Glenn is right:

… if we are in 1 month i would enter some value in B3 then A3 should change to (for example) 1
if we are in 2 month B3 and C3 would be populated and A3 should change to (for example) 2
and so on...

We'll see... Elvis seems to have left the theatre...

Yes, I think I misread it. Glenn is most likely the winner of this bout, but the OP has a solution either way when (if) they return.

Sry if i made cofusion, this is value for A3 for every month. Its fixed value.

2,3,5,7,8,10,12,14,15,17,19,20

I don't know which value i will enter at the end of the month in the fields B3-M3 but the value it self isn't important. Only important is, if field have any value then A3 should change accordingly.

at the end of the first month only B3 have value
at the end of the second month only B3 and C3 have value
and so on till M3

if it help you to make easier formula i could populate in advance B3-M3 with 0.

You don't need to change anything, just pick a winner. Do you want month (Glenn) or value (Ali)?

May be

=IFERROR(LOOKUP(2,1/($B3:$M3<>""),{2,3,5,7,8,10,12,14,15,17,19,20}),"")

However, if neither of us is right, then please provide the mock-up you suggested.

Thanks for feed back. I feel it is always better to provide maximum information to get early and good solution.