Using =IF(find_input_value(J$2,$A199)="",I199,find_input_value(J$2,$A199))

Here is the code associated:

Function find_input_value(target_date, target_row)

    Column = search_array(target_date, array_name, "Column", 2, 45)
   
    'MsgBox array_name(7, 1)
    'MsgBox (Column)

    'Row = search_array(target_row, array_name, "Column", 4, 400)
       
    Row = search_array(target_row, array_name, "Row", 1, 450)
    'MsgBox (Row)
   
    find_input_value = array_name(Row, Column)

find_input_value looks like a user defined function.  If it's not giving you a #NAME error, it is either defined in the VBA project of this workbook, or an add-in that you have loaded.

Have a look in VBA and see if you can find it. It will be looking for some string in J2 I'm guessing.

OK, I think I found it, just not sure why it is doing what it is doing.

Thanks

Sorry for the delay in responding - we need some more user-defined functions, because search_array and array_name must also be defined in your macro project.  It would be probably simpler if you could post the workbook in question to avoid having to come back to you again.