returning table data based on 3 criteria using INDEX and nested IF

I have carried out the same steps as per the instructions via the following youtube video but i cannot seem to the formula to work when i add in a 3rd IF criteria

I tried to adapt to a IF(AND... but this did not work for me either

Can anybody help me with this as i really need to get this to work

the formula looks like this

a. using IF(... for 3 criteria

Please Login or Register  to view this content.

b. using IF(AND...

Please Login or Register  to view this content.

This isn't how you nest multiple criteria in an IF statement. The IF statement should take the following form:

=IF(criteria, value if true, value if false)

But yours looks like so:

=IF(criteria, value if true, value if false, new if statement...

You need to nest your IF statements correctly, but to help it would be useful to upload a sample workbook with sensitive data removed.

Or alternatively you could do it like so:

=IF(AND(criteria1, criteria2, criteria3),value if true, value if false)

hi seasider89,

thanks for your response

a. re correct nesting of IF criteria, according to the formula excel bar i am correctly nesting my 3 IF tests

b. i have tried using the IF(AND as part of this nested formula as it sounds like the way to go but i cant get this to work at all

i have attached a sample spreadsheet which shows this problem and what io am trying to achieve

how do i upload a file? sorry i am new to this site and cannot see the upload file button

test-list.xlsx

see attached test file to see what i am trying to achieve

any help would be welcome, thanks

is anybody able to help me with this?

Can you explain what exactly you are trying to acheive with the formula, and based on the data what you expect the correct formula to return?