Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Fixing =Lookup

EE Pros,

I have a problem with Lookup.  I've attached the sheet I'm trying to do the function with.  For some reason it will not work in cells L41, M41, N41 and I cannot figure out why.



Please see if there is "a tweek" to fix this.

Thank you in advance,

B.
Lookup-fix.xlsm
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Lookup requires the looked up list to be in ascending order else the results would be unpredictable.
Avatar of Bright01

ASKER

I think there is a way around that using v or h lookup and a False reading..............

any idea?

B.
The data changes and is random so I cannot simply sort the field once and rely that it is always assending.  Which field has to be assending?
B.
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
how?  is match a function?  how do you combine it with index?  can you use the sheet I sent to show me?

b
got it.  ty byundt...let me try it
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Brilliant!  Thank you.  And learned something new on Indexing and Matching.

Thank you very much!

B.