Forum Discussion

Copper Contributor

May 18, 2017

What am I doing wrong?!?!

Hey y'all, I'm new here. I'm trying to work an index match issue. The following is what I have written: =MATCH("DFAS-CLEVELAND CRSC PAY ***********4936",CheckRegister5[TRANSACTION],0)&INDEX(C...

excel

Yury Tokarev

Steel Contributor

May 18, 2017

Hi Lugnutt,

you need to put MATCH instead of the hard-coded 7 in the second argument of the INDEX function. Please try the formula below

=INDEX(CheckRegister5[DEPOSIT],MATCH("DFAS-CLEVELAND CRSC PAY ***********4936",CheckRegister5[TRANSACTION],0))

Yury