This image is of my data. I am running an INDEX method to get the invoice number. It is working on all other rows but this one although they all have the exact same formula. I eventually found that it is pulling data from the row underneath where it is supposed to. The formula shows it is pulling from 4 rows above. I must be missing something with the INDEX function that's making it pull the wrong row for this formula
Here is the page showing the result so you can see the other numbers pulling correctly but this one pulling the "WHAT?" that I entered.