Cross lookup using Index and Match

Copper Contributor

bcroft_0-1602775881581.png

 

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:

rowcolumnindex
=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?

1 Reply

@bcroft 

That could be

image.png