Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Data Formula

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.

share|improve this question

migrated from stackoverflow.com Dec 28 '11 at 23:41

This question came from our site for professional and enthusiast programmers.

2 Answers 2

up vote 3 down vote accepted

Your MATCH function is doing a lookup in range I:I, that is, column I starting at row 1. Your INDEX range is A5:N2492 that is, starting at row 5. Therefore all results will be offset by 4 rows. Change INDEX to reference A:N and you should be Ok

share|improve this answer
    
Thank you so much! –  Zombian Dec 29 '11 at 0:04

Index gives you the index of the column within the range, is is possible that your range starts four rows lower?

Yeah, it looks like your range is A5:N2492 Which means, if you index 1, then it will return what is in the A5 block.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.