Cross lookup using Index and Match

Occasional Visitor



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.





Match Formula works but the Index returns in error, What am i missing?

1 Reply


That could be