Hello
Im trying to connect 3 sheets data into one sheet Calendarview. I set column “Appointment Date” as a key in all sheets and used a column “Type” as the ref type within the Calendarview sheet. I tried using the IF to determine whether the Type input matched the name of the TYPE sheet which would be for example “Blue, Red, Green”.
But not sure which way would be best to connect sheets into one sheet. Not sure what Im doing wrong…
LinkedIn
Twitter
