Pulling data from one sheet to another

[Thirsty76]

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

[sandy666]

Show (formula) what are you trying to do or
Attach a sample workbook (not a picture). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[deneh]

Sounds like an Index Match function is what you are looking for - a much more powerful lookup!

=INDEX(range, MATCH(lookup_value, lookup_range, match_type))

Range - where the product reference and price is
lookup_value - the product name or reference
Lookup_range - where excel should look for the name or reference in the product database
match type - use 0 for exact match

You will need to set this up for each column to give reference and price. As Sandy has said if you need further help post some sample data.

There are plenty of help pages on this function. Hope this helps