Concatenating Two Columns

[nujwaan]

Hi there,

I'm doing a spreadsheet that tracks projects and the cost of them.

The bit i'm stuck on is autopopulate several forms with something I put in the Team Members sheet (see attached). I've made a vlookup that gets someone's grade depending on their name -no problem

I then need to concatenate the Name and Grade to go into the cell D29 in the format - Name1 (Grade1), Name2 (Grade2)...etc.

However if the row is blank then I don't want it to concatenate otherwise i just get - Name1(Grade1), (), (), ()....

Can you help?

After that I'd like the Grade I entered in this sheet to be transferred into the resource calculator sheet so that it automatically calculates the costs.

I know this is confusing but any help is greatly appreciated!!

Nujwaan.