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?