Forum Discussion

Lugnutt ...'s avatar
Lugnutt ...
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(CheckRegister5[DEPOSIT],7)

 

when this formula returns the data it adds the "7" to the data inside the cell I'm looking to get the data from. Like this:

71522

 

WHAT HAVE I DONE!!!!

excel
  • Lugnutt ...'s avatar
    Lugnutt ...
    Copper Contributor
    May 19, 2017
    OMIGOSH! Thank you Mr. Tokarev! It worked just like I had envisioned. I've been wanting to punch myself in the face for two days! Maybe I'll just punch this Excel for Dummies book in the face instead. I'd track down the author but that might be rude on my part. I am one of the dummies the book was written for. Thanks again! Dennis
  • Yury Tokarev's avatar
    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

Resources