# Lookup and order

1. ## Lookup and order

Hi,

I need to lookup and order dates from earliest till latest based on a company name and a month number.

2. ## Re: Lookup and order

Try this in I6:

=IFERROR(SMALL(IF(I\$3&J\$3=D\$3:D\$16&B\$3:B\$16,C\$3:C\$16),ROWS(\$1:1)),"") Ctrl Shift Enter

3. ## Re: Lookup and order

Hi,

this formula doesn't work
i got a error: too many arguments in this if function.
have you tried it and if possible can you share with me the file

4. ## Re: Lookup and order

I also tried this one but not get the result.

5. ## Re: Lookup and order

this formula doesn't work
I guess you mean that you can't get it to work on your end. It works fine on my end.

=IFERROR(SMALL(IF((D\$3:D\$16=I\$3)*(B\$3:B\$16=J\$3),C\$3:C\$16),ROWS(\$1:1)),"") Ctrl Shift Enter

I have inputted both formulas into the sample that you shared in post #1 and attached it here for you to see.

6. ## Re: Lookup and order

The formula works fine for me.

double check if your seperation key is a comma or a semicolon

Formula:
`Please Login or Register  to view this content.`

And make sure you enter it as an Array Formula, that means that you need to confirm it with CTRL+SHIFT+ENTER, instead of just enter.

You will see if this worked when you see these "{" "}" brackets around the formula. (adding these manually doesn't work)

7. ## Re: Lookup and order

Here's a non-array (just enter...) alternative:

=IFERROR(AGGREGATE(15,6,\$C\$3:\$C\$16/((\$B\$3:\$B\$16=\$J\$3)*(\$D\$3:\$D\$16=\$I\$3)),ROWS(\$1:1)),"")

Please amend your location to show us,in general terms, where you are in the world. lulu may mean Honolulu, but might also mean....????

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1