Cross lookup using Index and Match

Question

&nbsp;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.&nbsp;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)&nbsp;Match Formula works but the Index returns in error, What am i missing?

sergeibaklan · Answer

bcroft&nbsp;
That could be

Forum Discussion

Cross lookup using Index and Match

1 Reply

Resources

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)