+ Reply to Thread
Results 1 to 14 of 14

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

  1. #1
    Registered User
    Join Date
    02-22-2022
    Location
    croatia
    MS-Off Ver
    2007
    Posts
    3

    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
    Attached Files Attached Files
    Last edited by sheet007; 02-22-2022 at 05:20 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    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.
    Attached Files Attached Files
    Last edited by AliGW; 02-22-2022 at 05:25 AM. Reason: Workbook attached.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

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

    I thought it was this:

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



  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    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. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,319

    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...
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

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

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

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    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. #9
    Registered User
    Join Date
    02-22-2022
    Location
    croatia
    MS-Off Ver
    2007
    Posts
    3

    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

    if it help you to make easier formula i could populate in advance B3-M3 with 0.
    Last edited by sheet007; 02-22-2022 at 07:00 AM.

  10. #10
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,319

    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. #11
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,099

    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}),"")
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,644

    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. #13
    Registered User
    Join Date
    02-22-2022
    Location
    croatia
    MS-Off Ver
    2007
    Posts
    3

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

    solution by kvsrinivasamurthy worked for me. Thx

  14. #14
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,099

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding All Values ​​Entered Separately In Excel In A Single Cell
    By t3qnee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2021, 10:45 AM
  2. [SOLVED] Code option of placing multiple values ​​in one cell (via a list box)
    By Prangendevraag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2020, 02:58 AM
  3. Register dynamic values ​​in static values ​​via VBA
    By edneipaula in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2019, 08:57 AM
  4. Replies: 1
    Last Post: 03-25-2014, 10:46 AM
  5. Replies: 0
    Last Post: 11-27-2013, 09:11 PM
  6. Replies: 7
    Last Post: 11-23-2012, 08:40 AM
  7. [SOLVED] VBA to sum values ​​based on the values ​​in column
    By young_86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 11:49 AM

Bookmarks

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