Multiple Small Queries

With an IF function, you have to carry out some comparison which will result in either TRUE or FALSE, and then you can have one of two actions. It's not clear from your description, or from your formula, what the comparison is.

Are you trying to say that if A2 is the smallest number then you want to return A2, otherwise a blank?

How does that then square with joining the formulae together? If A2 is the smallest number then return A2, otherwise if it is the second smallest then return A2, otherwise if it is the third smallest number then return A2 ... else return a blank. I don't understand what you want to achieve - perhaps you can explain again (in English, not Excel formulae) what it is that you want to do.

It would help if you attached a sample Excel workbook. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Example-Small.xlsx

Hi Pete,

Hopefully the attached has worked

Data gets entered to M:M
I have a "Small" list in "N"
if the smallest from either M or N belongs to box 1 then A2, or A13 etc etc

Sorry, may just be me not explaining correctly...