I have to input sales on a sheet. There are a list of products and prices. On one tab and the data is input on another. I've tried VLOOKUP but it's unsuccessful
The data I'm entering is product name, ref and price.
Is there a way I can make the reference and price auto fill when I type the product name?
TIA
Bookmarks