HI ALL,

I am probably over complicating things and cant see the wood through the trees.

I am trying to vlookup coloumns referencing two criterias.

A receipt has a date, which falls between 5 lines of between dates, which I have datefrom dateto columns,  then a further criteria is the description line being say "fuel"

if fuel is selected, the result is 3114, R (then depending on the date, Prepfu, block1,block2,block3,postfu in the set column

I have tried to list the code in current columns, as per the uploaded picture.



I keep getting errors.  I have taken the "=" out of the equation to display the formula.

in my mind I have

The date if looked up against two dates