i have a data sheet where col c is date, col d is price the range is from
line 11 down to 300 or end of data
and a test sheet where $F$5 is a date and F8 is a price.

i am trying to write a vlookup in test sheet that will find the line in data
sheet with a date and a price that match F8&F5 in test sheet then do the
following if statement but use matching data line on data sheet instead of
line 11

=IF(C8="C",IF(AND(C8="C",B8="B"),data!H11,
data!G11),IF(AND(C8="P",B8="B"),data!P11, data!O11))

thanks