Hi, I have used a formula in a cell to produce the code for a given name =VLOOKUP("Bob",People!A1:B20,2,FALSE)my question is how do I get in the next cell get the code plus the invoice number, e.g B01/001, the invoice data is in column A on the same worksheet.
Thanks
Charlie
Thanks
Charlie