mardi 28 juillet 2020

Referencing data

I have a sheet that has two columns, name and date. It is pulled from another workbook that pulls data from a Google Form. I import that data on a sheet called 'Data'The next 5 sheets in that workbook are formatted as a calendar months. When the date in the Data sheet equals say August 3rd, I want the name associated with that date (same row) to show up in the calendar cell for that day. How do I do the formula for this? I know its an =IF formula but all the references are confusing me. Yes, I know I'm a novice but this is what happens when a fireman tries to use technology.... Thank you in advance.

Aucun commentaire:

Enregistrer un commentaire