From the Help file LOOKUP()
---------------------------------------------------------------
Lookup_vector is a range that contains only one row or one column. The
values in lookup_vector can be text, numbers, or logical values.

Important The values in lookup_vector must be placed in ascending order:
....,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give
the correct value. Uppercase and lowercase text are equivalent.
---------------------------------------------------------------

So..you gotta sort BG in ascending order

"Tom" wrote:

That worked fine, but I still can't solve the underlying problem.

The formula is such: =LOOKUP(BG270,BG10:BG$267,B10:B$267)

Line 270, Column B should display what is in B171, but it isn't. Instead it
is going up the sheet and displaying information that isn't asked for in the
formula.

FYI: Line
146| 139 7/21/06 5.92


A B BG
169| 162 8/23/06 62.29
170| 163 8/24/06 61.03
171| 164 8/25/06 40.13
172| 165 8/28/06 65.77

268| 162 8/23/06 62.29
269| 163 8/24/06 61.03
270| 139 7/21/06 40.13
271| 165 8/28/06 65.77

Any suggestions?

Thanks,

Tom







"Duke Carey" wrote:

Select the cell
Press the F5 key
Click on Special
Click on 'Dependents'
Click on OK

"Tom" wrote:

Is there a way for me to see what cells within a workbook, or worksheet, are
referencing a specific cell?

I had all data on one worksheet, then I cut 1/2 of it and pasted it into
another worksheet and consequently one cell in the original worksheet is now
returning inaccurate info.

Any assistance would be greatly appreciated.

Tom