Nel post
*Ross* ha scritto:

Im not really sure what VLOOKUP to use or where to start I want to
return the HDR data from belwo table using a reference cell stating
"S59" and a cell stating the Date "1/4/2006 00:00"

Code ProdDate OnLine Hdr
SP59 01/04/2006 00:00 24 HDR2
SP69 01/04/2006 00:00 24 HDR1
MS19 01/04/2006 00:00 0 TEST
SP28 01/04/2006 00:00 0 SHUT
SP33 01/04/2006 00:00 24 HDR1
SP50 01/04/2006 00:00 24 HDR2

Thanks,

Maybe you can add a first column in which you can concatenate the code and
the date and then use a VLOOKUP funcition like this:

=VLOOKUP(A2&A3,A5:D8,4,FALSE)

where in A2 you put the code (S59) and in A3 the date (1/4/2006 00:00) you
want to search for.

Adjust the references.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy