I can't get =LOOKUP(B2;Imenik!A:A;Imenik!B:B) to execute in Office 2010. The formula definition just sits there in the cell and is not executed.
hi
why you select entire column A and B
and does your data in column A in Ascending order
Ensure the cell is format as General and then re-enter the formula.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
It works after reformatting the cells as General and sorting the Imenik spreadsheet in ascending order.
However, it also finds approximate matches. How can I make it do exact matches, only?
If you wish to avoid the need to sort your data in the first instance and find exact matches then use VLOOKUP rather than LOOKUP:
else, with sorted data and LOOKUP you can use exact match by virtue of repetition:=VLOOKUP(A2;Imenik!$A:$B;2;0)
Sorted data allows for more efficient calculations, however, in this case I suspect VLOOKUP would make more sense.=IF(LOOKUP(A2;Imenik!$A:$A)=$A2;LOOKUP($A2;Imenik!$A:$B);"")
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks