white_flag
02-18-2011, 12:19 PM
Hello
I have this array
col1
125
145
136
189
569
578
145
256
etc
and I have the second array
col1......... col2
132..........the first bigest value from array1 IF do not match
156
185
254
269
369
287
569
etc
it is possible to tell to vlookup to find the value from array1 and if did not mach the value to take the FIRST bigest value from the array1.
I have this array
col1
125
145
136
189
569
578
145
256
etc
and I have the second array
col1......... col2
132..........the first bigest value from array1 IF do not match
156
185
254
269
369
287
569
etc
it is possible to tell to vlookup to find the value from array1 and if did not mach the value to take the FIRST bigest value from the array1.