#### spaceman2155

##### New member

- Joined
- Nov 26, 2013

- Messages
- 2

- Reaction score
- 0

- Points
- 0

I need a formula so if cell "P2" contains the values "2, 3a, 10" then the formula will look at a different

**Sheet 3**(see below) and pick out "Management Fee, Loan Interest and Tenancy Registration Fees" and combine this text in cell "AX2", The text if possible should have the code then a space the text and then a carriage return.

**Sheet 3 information below**

Code | Type |

1 | Advertising |

2 | Management Fee |

3a | Loan Interest |

3b | Insurance on Building |

3c | Life Assurance |

4 | Environmental Waste Charges |

5 | ESB |

6 | Gas |

7 | Tolls & fuel |

8 | Phone |

9 | Bank Charges |

10 | Tenancy Registration Fees |

So what I am trying to achieve is that the cell "AX2" would be as follows:

2 Management Fee

3a Loan Interest

10 Tenancy Registration Fees

I will be copying this formula down about 1500 cells.

I have tried split the values in one cell by "Text to Columns" and then I have used "=CONCATENATE(VLOOKUP(BB2,Sheet3!$A$2:$B$14,2,FALSE),VLOOKUP(BC2,Sheet3!$A$2:$B$14,2,FALSE),VLOOKUP(BD2,Sheet3!$A$2:$B$14 ,2,FALSE),VLOOKUP(BE2,Sheet3!$A$2:$B$14,2,FALSE),VLOOKUP(BF2,Sheet3!$A$2:$B$14,2,FALSE), VLOOKUP(BG2,Sheet3!$A$2:$B$14,2,FALSE),VLOOKUP(BH2,Sheet3!$A$2:$B$14,2,FALSE), VLOOKUP(BI2,Sheet3!$A$2:$B$14,2,FALSE))"

if works great for a where all the values are used, but if I have two values in one row and the next row down I will have values, since some cells will be blank, this is giving N/A in the cell AX2, I am told I could try adding =concatenate(if(isna(vlookup..... but this is giving to many arguments and I cannot find the problem.

Thanks,

John