Multiple IF arguments per cell error?

[katb85]

Hi All,

I am trying to do multiple if arguments, per cell, is this possible?

current IF formula is =IF(A44=Lists!D2,Lists!E2, "")

but I would like it to be =IF(A44=Lists!D2,Lists!E2, "") then for it to also look at =IF(A44=Lists!D3,Lists!E3, "") and so on.

Is this possible, I have tried =IF(A44=Lists!D2,Lists!E2, "", IF(A44=Lists!D3,Lists!E3, "")) but it tells me I have entered to many arguments.

Cheers,
Kat

[AliGW]

You have to nest IF statements like this:

=IF(A44=Lists!D2,Lists!E2,IF(A44=Lists!D3,Lists!E3, ""))

and

=IF(A44=Lists!D2,Lists!E2,IF(A44=Lists!D3,Lists!E3,IF(A44=Lists!D3,Lists!E3 "")))

and so on.

However, it might be easier this way:

=IFNA(VLOOKUP(A44,$D$2:$E$3,2,0),"")

Extend the lookup array to suit your requirements.