Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

John1988

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by John1988

  1. Hi, I am wondering if you can use If formula and vlookup in the same formula. for example I have 3 sheets of data titled 2020,2021,2022 and I have an initial sheet - say if the output is x then I need the data from 2020 or if y use 2021, or if Z use 2022 can this be done?
×
×
  • Create New...