I have the following formula that looks up in three separate tables ... and now I'd like to add in a fourth lookup but I can't get the syntax right. Can anyone help?
=IF(ISNA(VLOOKUP($BC$1;$CD$3:$CF$14;2;FALSE));(IF(ISNA(VLOOKUP($BC$1;$CT$3:$CV$14;2;FALSE));(IF(ISNA(VLOOKUP($BC$1;$DJ$3:$DL$14;2;FALSE));"";CONCATENATE(VLOOKUP($BC$1;$DJ$3:$DL$14;2;FALSE);" - ";(VLOOKUP($BC$1;$DJ$3:$DL$14;3;FALSE)))));CONCATENATE(VLOOKUP($BC$1;$CT$3:$CV$14;2;FALSE);" - ";(VLOOKUP($BC$1;$CT$3:$CV$14;3;FALSE)))));CONCATENATE(VLOOKUP($BC$1;$CD$3:$CF$14;2;FALSE);" - ";(VLOOKUP($BC$1;$CD$3:$CF$14;3;FALSE))))
Probably something like:
=IFERROR(VLOOKUP($BC$1;$CD$3:$CF$14;2;FALSE)&" - "&VLOOKUP($BC$1;$CD$3:$CF$14;3;FALSE);IFERROR(VLOOKUP($BC$1;$CT$3:$CV$14;2;FALSE)&" - "&VLOOKUP($BC$1;$CT$3:$CV$14;3;FALSE);IFERROR(VLOOKUP($BC$1;$DJ$3:$DL$14;2;FALSE)&" - "&VLOOKUP($BC$1;$DJ$3:$DL$14;3;FALSE);""))
