Vlookup table error when Lookup_value uses dates but there are gaps in the dates

[JimBoBz]

Excel noob here. I am trying to create a vlookup that uses dates as the lookup value, my table array has data/date gaps so I end up with an error when it hits the 1st date gap. is there a way to work around this?

=VLOOKUP(A2,'Created - priority '!A2:F1333,2,FALSE)

ok until it hits 25/03/2020 (covid lockdown)

the table array has date gaps ( data was pulled from an SQL database) and has gaps all through lockdown

 

[arthurbr]

Perhaps

=IFERROR(VLOOKUP(A2,'Created - priority '!$A$2:$F$1333,2,FALSE),"")

( did you omit the absolute referencing on purpose?)

 

[SunnyAlv]

try this

=IFERROR(XLOOKUP(A2,'Created - priority '!A:A,'Created - priority '!B:B,"")