Forum Discussion

Deleted's avatar
Deleted
Jun 27, 2018

Need Help Changing Nested IF formulas to Vlookups

Hi there,   I am in the process of trying to clean up Nested IF(AND formulas and converting them to Vlookup tables.  I am having a very difficult time trying to figure out how to create some of the...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 27, 2018

Hi Kristin,

 

Perhaps

=  IFERROR(IF(CD4=2018, MIN(INDEX({80,90,84,96},MATCH(Shift,{8,9,10.5,12},0)),CB4*Shift), FALSE),FALSE)
  • Deleted's avatar
    Deleted
    Jun 28, 2018
    Thank you Sergei. The formula doesn't seem to work, but I found another way.

    thank you for your help
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 28, 2018

      Hi Kristin,

       

      That's okay, thank you for the feedback. If you have time could you please to clarify what's wrong with the formula - on my fast test all three give the same result

      and attached.

      Thank you

       

Resources