Create a concatenated lookup that will only lookup from populated cells and ignore blanks

[Taggsuk]

Hi,
I'm struggling to create a function that will look across a range of 10 cells. % will be populated with letters such as "M". They following works if the first five cells are populated but I need a function that will ignore the blank cells. It also looks at the persons name and gender but I can do that. Having problems with the blanks. Though maybe using MOD?
Any help would be most appreciated




=CONCATENATE(B3," ",VLOOKUP(G3,'T1 Skills'!$B$5:$C$8,2,FALSE)," ",'T1 Data'!AL3," ",VLOOKUP('T1 Data'!H3,'T1 Skills'!$B$12:$C$15,2,FALSE)," ",B3," ",VLOOKUP(I3,'T1 Skills'!$B$19:$C$22,2,FALSE)," ",AL3," ",VLOOKUP(J3,'T1 Skills'!$B$26:$C$29,2,FALSE)," ",'T1 Data'!B3," ",VLOOKUP('T1 Data'!K3,'T1 Skills'!$B$33:$C$36,2,FALSE)," ",'T1 Data'!AL3," ",VLOOKUP('T1 Data'!L3,'T1 Skills'!$B$42:$C$45,2,FALSE)," ",B3," ",VLOOKUP(M3,'T1 Skills'!$B$49:$C$52,2,FALSE)," ", 'T1 Data'!AL3," ",VLOOKUP('T1 Data'!N3,'T1 Skills'!$B$56:$C$59,2,FALSE)," ",'T1 Data'!B3," ",VLOOKUP('T1 Data'!O3,'T1 Skills'!$B$63:$C$66,2,FALSE)," ",'T1 Data'!AL3," ",VLOOKUP('T1 Data'!P3,'T1 Skills'!$B$70:$C$73,2,FALSE))

 

[Special-K99]

Just place IF(cell="","",VLOOKUP(...)) areound each cell you are checking for (if you can fit it all in), e.g.

=CONCATENATE(B3," ",IF(G3="","",VLOOKUP(... etc )), ...