How to get item description automatically Excel?

[sanpt7777]

Hey guys, I'm working on an Excel file for my dad's furniture store to make it easier to get quotes on the moment for customers. It's very simple and it adds all the prices of items into a total with tax.

I now want to make it work so you type the item code in one column and get the description and price in the following two. I tried the VLOOKUP function but I can't get it to work.

My price and product description would be all in another sheet to keep it clean.

The red box is were the code is typed in, the green and yellow should automatically display descritption and price of the item based on the code provided


How would you do this?

Thanks!

 

[martinbo]

VLOOKUP does work - here's the syntax:

For description:
=VLOOKUP(C3,Sheet1!$C$2:$E$7,2,FALSE)

For price:
=VLOOKUP(C3,Sheet1!$C$2:$E$7,3,FALSE)

Notice the $Column$Row to (":") $Column$Row syntax. This is important in fixing the range of the array within which VLOOKUP has to search.

It appears to me that you have merged columns D E F for description. That was a superfluous step - why not just stretch Column D to accommodate the description length?
You can use merged cells with VLOOKUP but Excel is fussy when it comes to Merged Cells and copy/pasting so you have to be more systematic when copying the formula(s) to other cells.

 

[sanpt7777]

Thanks man, I'm gonna try it like that.

Shouldn' I just change the Sheet1 to Sheet2? I'm keeping all the data in Sheet2

Edit: Still no luck. I think the problem lies in trying to retrieve data from other sheet. I'm gonna try it in the same sheet

 

[martinbo]

The data can lie in any sheet.

 

[sanpt7777]

Thanks a lot. I couldn't make it work to save my life with the existing file.
I created a new file and tried the function there and finally it worked. I made everything again from scratch, this time I did not merged the cells.

Everything is perfect now!
Thanks man