Concatenate with offset / abstract reference

[melvinkoshy]

I have a table with Area, Item and Output as fields. For functional propose, I wish to keep the ‘Area’ name only once, in other words, I do not intend to drag down the ‘area’ filed to each ‘item’ field. Hence, I desire to obtain the output as concatenation of ‘area’ and ‘item’ field but with offset. The normal CONCATENATE function does not take into account.

[samba_ravi]

C2=IF(B2="","",LOOKUP("zzzz",A$2:A2)&"-"&B2)
Try this and copy towards down

[Phuocam]

Try this in C3:

=IF(B3="","",LOOKUP("zzzzzzz",$A$2:A2)&"-"&B3)