Answer for:

Excel 2010 - VLOOKUP issue

Message 2 of 3

View entire thread
0 Votes

I created a blank Excel document and typed the values and formula's in as per your screenshot and it works fine. I suspect there's something external getting in the way that's not visible from the screenshot you posted.

I would start with a new Excel document and do what I did - type it in and get *something* working. Then start copying and pasting in bits from your original document until it breaks.