I am trying to write a macro that looks down a certain column for the word
"day" if it finds it, it then looks through a column of other data for the
word "day" and pastes it into my current cell. If it doesnt not say "day" it
just equals the cell above it.

=IF(RIGHT(B42,6)="day",VLOOKUP(B42,Index!$A$4:$H$5 03,6)," ")

kinda what im going for.