i am trying to write a vlookup statement that will find the row of data if a
date in data sheet col c matches a date in the cell of another sheet.

if vlookup finds a matching date in data sheet col range c10:c100 that
matches a cell b5 in test sheet then
K8=IF(AND(C8="c", B8="b"),data!H11, Data!G11)

thanks