Oct 15 2020 09:37 AM - edited Oct 15 2020 10:00 AM
the blue table is on one sheet the input values is on another, The table gets pulled as a report and i manually enter the input data. What im looking for is to auto populate the assets when i input the account number. Note the report does not input the "-0001" so to resolve this ive been using -left, =right to separate them.
now:
row | column | index |
=MATCH(E9,A:A,0) | =MATCH(F9,4:4,0) | =INDEX(A4:N5,G12,I12) |
=MATCH(E10,A:A,0) | =MATCH(F10,4:4,0) | =INDEX(A4:N5,G13,I13) |
Match Formula works but the Index returns in error, What am i missing?
Oct 15 2020 10:01 AM