Sverweis-Frage
J
____________________________________________________________________________
Range("E17").Select
ActiveCell.FormulaR1C1 = _
"=IF(RC[-2]>"""",IF(R5C18=""Verwaltungen"",VLOOKUP(RC[-2],R2C47:R20C49,3),IF(R5C18=""Kliniken"",VLOOKUP(RC[-2],R2C32:R20C34,3),IF(R5C18=""Schulen"",VLOOKUP(RC[-2],R2C40:R20C42,3),IF(R5C18=""Alten-Pflegeheime"",VLOOKUP(RC[-2],R2C61:R20C63,3),0)))))"
_________________________________________________________________________________
Danke für entsprechende Hinweise