I've been going round in circles with this for hours and am close to giving up so any help gratefully received!

I have an invoice sheet with a defined table (Product Code, Product, Quantity, Cost Per Unit, Total) and a second sheet called Products with another defined table (Product, Product Code, Cost Per Unit). On the invoice I want to be able to select the Product cell on the invoice which is a drop down showing the various products on the Products sheet. I've managed that using data validation.

Next I want the other cells on the invoice to be populated based on the product I've chosen. I figured this would be with VLOOKUP. So my formula for the Product Code on the invoice is this: =VLOOKUP([@Product],tbl_products,2) but whatever I try I either get #N/A or it pulls in totally the wrong values.

On my products sheet there are gaps because I've used headings for each type of product and there are also characters like ' and " in the Product column (e.g.5'6" Round Table) Could this be my problem?