excel - Is it possible to write a VBA code that searches for the exact same data or the closest one in the past? -

excel - Is it possible to write a VBA code that searches for the exact same data or the closest one in the past? -

i have 2 excel wordbooks. 1 has parameter changes on dates , other has dates on juice has been produced. this

spreadsheet 1

date of parameter alter %apples %oranges 30/09/2014 55 45 25/09/2014 50 50 20/09/2014 45 55

spreadsheet 2

date of created juice %people liked %apples %oranges 26/09/2014 88 22/09/2014 91

and want re-create % parameters of apples , oranges sec workbook result looks like

date of created juice %people liked %apples %oranges 26/09/2014 88 50 50 22/09/2014 91 45 55

so if juice made on 26/09 illustration want have parameters used juice. parameters of 30/09 weren't used parameters of 25/09 used because it's day before juice has been made.

is possible create vba? show me how date searching part @ least? much appreciated!

you can utilize vlookup formula rather using vba.

the syntax of vlookup follows:

vlookup(lookup_value, table_array, col_index_num, [range_lookup])

to find approximate match value looking for, can set range_lookup parameter true

excel vba excel-vba