John1988 Posted July 25, 2022 Share Posted July 25, 2022 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? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.