Forum Discussion
Conditional range
Hello to all, I'm trying to create a spreadsheet that will keep track of my studying and preparation for a big exam. I'm using space repetition to learn. So in my spreadsheet I have the date tha...
Create a range that lists the rankings and corresponding number of days to be added.
Convert the range to a table (Insert tab of the ribbon > Table).
It'd look like this (I made up the days, obviously).
You can then use XLOOKUP or VLOOKUP to calculate the next study date:
Formula in D2:
=B2+XLOOKUP(C2,Table2[Ranking],Table2[Days])
where Table2 is the name of the table.
Thanks!!
So I did what you said and I can only do it for one date then I'll get the error. I'm trying to go across with this formula. How do I remedy this? I appreciate your assistance.
You switched Days and Ranking in the XLOOKUP part.