Vlook for dates and share price

dates in column a are text
=VLOOKUP(VALUE(A3),G3:$H$3349,2,FALSE) works or change col a to real dates
select column a data/text to columns next next select dmy click finish

??? why to text, to real dates is probably best
besides that when i open it i see this,looks ok
but
what is the 2 for?
=VLOOKUP(A3,$G$3:$H$6205,2,2) it will work but is just wrong its the same a putting TRUE
it should be true or false and for an exact match you use FALSE
=VLOOKUP(A3,$G$3:$H$6205,2,false) or =VLOOKUP(A3,$G$3:$H$6205,2,0) (to all intents 0=FALSE any other number = TRUE)
if it was TRUE your dates in each column G I K would need to be sorted ascending then vlookup would find he largest value that is less than or equal to lookup_value.

hi xtasio, why did you use "2" for the last argument of VLOOKUP? use FALSE like martin mentioned or 0:
=VLOOKUP(A3,$G$3:$H$6205,2,0)

do the same for the other 2. to counter errors when the dates are not found, use IFERROR (available only from 2007 onwards):
=IFERROR(VLOOKUP(A3,$G$3:$H$6205,2,0),"")

to do a standardised formula throughout Column B to D, try:
=INDEX($G$3:$L$6205,MATCH($A3,INDEX($G$3:$L$6205,,MATCH(B$1,$G$1:$L$1,0)),0),MATCH(B$1,$G$1:$L$1,0)+1)

your dates are not real dates. but since they are all not real dates, you can continue to use them i guess. as long as it's standardized. to convert to real dates, martin also mentioned about Text To Columns.