Hello and Good Day,
I've used VLOOKUP for various jobs over the years, but am now stumped. I have a sheet that accumulates data from bank deposits (I work at a private school in Central America) that will then merge into receipts using Word. The VLOOKUP should search for the Deposit number (found in column C on the attached file) and then send the reciept no. value in column H to another sheet.
The problem is I don't get any N/A response... instead I just get a (seemingly) random answer from the correct column. In the attached sheet you'll notice my test (other sheets deleted). The K column has four values I did for practice (none are repeated in C column). And the shaded yellow cells in L column should give the correct LOOKUP. But it doesn't.....
Something interesting I've noticed is that if I do the LOOKUP based on what is in column A (the record number), the LOOKUP works fine. It seems like the problem is with column C values.. I checked for extra spaces or any odd value types and still can't figure anything out.
Thank you so much for your help
Regards,
Aaron Smith
Bookmarks