I created formula LOOKUP and all worked fine. Though now I have added one item in the LookupValue and I get as result #N/A. I tried everything but the results are always wrong as even that I choose one item but it takes the info from another item.
Anyone can help?
Not very clear.
Generally speaking LOOKUP requires lookup_vector be sorted in Ascending order - if you modified did you modify in that manner ?
Post a sample.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Wow. Thanks a lot. I have breaking my head on this.
Dear Forum Administrator,
This thread is solved though it doesn't give me the option to mark SOLVED. Can you maybe make this SOLVED?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks