trying to find a value in a large data set. Need to use multiple criteria which I have found with a filter function (2d array) but when I pair the lookup array (2d as well) it returns a value. Can't tell in the formula eval if it is pairing correctly. If I split the 2d lookup array into single arrays then I can use the & operator to get it to work. Does excel support 2d spilled array lookup?
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here it is sorry about that.
What do you expect the result to be if there are 2 matches found?
like in the example below:
AAL AMERICAN AIRLINES GROUP INC 5.5
AAL AMERICAN AIRLINES GROUP INC 4.625
I'd expect the first match for both of them.
did you try VLOOKUP?
see if this works for you:
=FILTER(VLOOKUP(C3#,UNIQUE(FILTER(' data'!A:C,(' data'!D:D=B2))),3,0),{1,0})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks