Adding extra if statements

[ChalkerL]

Hi, I'm wondering if it is possible to include addition if statement only when more than 5 results are returned.

Currently I'm doing a multiple if statement , 10 results are returned from the formula, and i would like to add extra if statement to filter only the top 6 results.

You can see the formula in shortlisted Admin - B10

These are the additional if statements :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks

[Richard Buttrey]

Hi,

It's not clear entirely what the purpose of this big IF statement is. It just seems to be returning the NRIC number. Why not just list the names in column C of the Shorlisted.. sheet rather than a VLOOKUP and then useSurely you can just use

Please Login or Register  to view this content.

in B10 and copied down.

Incidentally there seems to be an inconsistency between the current B10 & B11 cells. B10 uses Row 2 whilst B11 uses row 4 rather than row 3.

However if you really need IF statements, (and they are getting rather unwieldy and hence difficult to read), can I suggest a better way would be to create a helper column in your Person Specification sheet. In this helper column concatenate all the columns that you are currently testing for in the big IF statement. i.e.

Please Login or Register  to view this content.

Then you can just use one IF statement and look at the helper column.

HTH

[ChalkerL]

Thanks for the suggestions.

The big if statement returns the nric, based on the comparison of two worksheets - jobsApplicationdb and Job Specification, and i'm checking if values in cells for both worksheets match, then return the nric.

You suggested using

Please Login or Register  to view this content.

Is it possible to do, if I'm using to worksheets?

Please Login or Register  to view this content.

In some of the if statements i had find, if i were to concatenate them, i might have trouble comparing.

Incidentally there seems to be an inconsistency between the current B10 & B11 cells. B10 uses Row 2 whilst B11 uses row 4 rather than row 3.

I actually hide the error in the nric column. Cause in the jobsApplicationdb the 2nd value is actually "KTP associate", but what i'm looking for is "Administrator" , so it displays only those with value and not those error.

Is it possible to add addition if statement when i can more than 10 results?