B
bob
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
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