Lookup is not working (Excel 2003)

Topic

New Reply

In the attached workbook I have some lookups on the Graph Data page that do not seem to be working. It only appears to be happening with the QTD Averages (starting in cell C37 of the graph data worksheet). The lookup formula works fine for the very first QTD average, but stops after that. What makes it even more perplexing is that all QTD Avgs work in columns B and F of that same sheet. Can someone take a look at this and let me know where I went wrong.

Thanks!!

Reply | Quote

Replies

The LOOKUP function only works correctly if the lookup list is sorted in ascending order; this is not the case. You can use VLOOKUP instead. In C37:

=VLOOKUP(A37,’Prod Data’!$A$2:$L$34,8,FALSE)

The FALSE argument specifies that you’re looking for an exact match. For an exact match, the first column does not need to ordered. (I didn’t bother using named ranges, but I hope you get the idea.)

Reply | Quote

Hans,

That worked beautifully.

Thanks again!

Reply | Quote