Link to home
Start Free TrialLog in
Avatar of gracie1972
gracie1972Flag for United States of America

asked on

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

I am working on cracking an old spreadsheet.
I dont understand this formula.

Column J2 = July2011
Column A199 = LiquidationDelin[]FC
Column 199= 73.3%

Can someone explain this?
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gracie1972


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.

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.