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

1. ## 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.

2. ## Re: value in a field that depends on values ​​in other fields

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.

3. ## Re: value in a field that depends on values ​​in other fields

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.

4. ## Re: value in a field that depends on values ​​in other fields

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

5. ## Re: value in a field that depends on values ​​in other fields

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.

6. ## Re: value in a field that depends on values ​​in other fields

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...

7. ## Re: value in a field that depends on values ​​in other fields

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

8. ## Re: value in a field that depends on values ​​in other fields

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.

9. ## Re: value in a field that depends on values ​​in other fields

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

10. ## Re: value in a field that depends on values ​​in other fields

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

11. ## Re: value in a field that depends on values ​​in other fields

May be

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

12. ## Re: value in a field that depends on values ​​in other fields

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

13. ## Re: value in a field that depends on values ​​in other fields

solution by kvsrinivasamurthy worked for me. Thx

14. ## Re: value in a field that depends on values ​​in other fields

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1