Hello
I need some help making a kind of a schedule/timetable.
In one spreadsheet I have a first column that has a given set of dates (e.g. between 1 jan and 31 march of 2022);
In the other spreadsheet i have columns that are numbered between 1 and 31 (the days of the month) and 3 lines with the name of the months (january, february and March).
So my question is how can i make the dates in spreadsheet 1 populate the timetable that is in the spreadsheet 2.
Any help will be appreciated.
Thanks and greeting
Hi @Ajadal, you can use VLOOKUP(). You have to build the search criterion with day and month. See here:
=IFERROR(VLOOKUP(VALUE(E$1&" "&$D2&" 2022"),$A$2:$B$91,2,0),"")
E1 is the day and D2 the month, for example: “January”. Calc then automatically recognises that you wanted to write a date and converts it with VALUE().
Enclosed is my example document.
Ajadal.ods (20,6 KB)
Thank you very much Dscheikey and Karolus
but i don`t understand why is the needed the colunn B (DATA);
but i may ask if it is possible to replace the numbers in colunn B, with for example, a X
(see please attached example)
Again thank you very much
Ajadal_2.ods (22.8 KB)
I am not so sure about what Data should go from 1 to 2 or the other way ??
in a first try I took @dscheikey 's
Ajadal_82689.ods (18.0 KB)
example and do some modifikations.
THANK YOU KAROLUS
I replaced the values in COLUMN B with “X” and it’s a go
Thank you very much