Need help debugging these formulas:
=IF($D$27="aetna",(IFERROR(VLOOKUP(J28,codes[#Data],2,FALSE),"")))&IF($D$27="delta",(IFERROR(VLOOKUP(J28,codes[#Data],2,FALSE),"")))
=IF($D$27="aetna",(IFERROR(VLOOKUP(J28,codes[#Data],3,FALSE),"")))&IF($D$27="delta",(IFERROR(VLOOKUP(J28,codes[#Data],4,FALSE),"")))
when entered, I get the word "FALSE" appearing either at front or back of answer, depending on which choice I make in D27.
Any help is appreciated.
=IF($D$27="aetna",(IFERROR(VLOOKUP(J28,codes[#Data],2,FALSE),"")))&IF($D$27="delta",(IFERROR(VLOOKUP(J28,codes[#Data],2,FALSE),"")))
=IF($D$27="aetna",(IFERROR(VLOOKUP(J28,codes[#Data],3,FALSE),"")))&IF($D$27="delta",(IFERROR(VLOOKUP(J28,codes[#Data],4,FALSE),"")))
when entered, I get the word "FALSE" appearing either at front or back of answer, depending on which choice I make in D27.
Any help is appreciated.