Hi everyone, First of all thank you for helping me out. This is what I have

Sheet 1 - List of Description

C1 = Name (C2 to C20 )
D1 = Description (D2 to D20)
E1 = Price (E2 to E20)

fe. Watch (C2) Cartier Watch Design from 2009 (D2) 500,000 Dollar (E1)

Sheet 2 - Invoice

A10 - Here I would wanna refer to a cell in Sheet 1 - (C2 to C20)

Is it possible to automatically put the matching description and price in B10 and C10

Thank you

If there is only one watch to look for, sure:

B10: =VLOOKUP(A10,C2:C20,2,FALSE)
C10: =VLOOKUP(A10,C2:C20,3,FALSE)

Gebobs, Thank you for your swift response.

What if the list is in another excel document instead of sheet 1.
Is it then also possible to refer to another excel document. Let's name that document List2013.exe

Yes you can.

Would it be possible to attach some samples of the sheets you want to use?

Hey Gebobs! Thank you so much for your help. I have the solution it seems. Thank you again

Oh, it isn't only just one watch to look for.
Depending on the item to look for, find the matching description and price.

If there is more than one, how should we know what to look for? We need a primary key...one that defines the record definitively.

If watch isn't enough, then what? Watch #3? Watch #2?

yeah, like for example

Watch Description Price
Armani Armani, blue rubber wrist HK$5,000,000
Armani Gold Armani, gold wrist HK$198,000
Cartier Cartier Jewellery wrist watch HK$248,000

and the list goes on and on.

so, there is actually a list of watches, with the matching description and price

I am sorry, here I am again with another question.

Everything is the same, except that I want to use a dropdown list instead of "Name" in A2 (SheetInvoice)

Now here it comes:

-----------------------------------------------
Suppose that given:

Sheet 1 - List of Description

C1 = Name (C2 to C20 )
D1 = Description (D2 to D20)
E1 = Price (E2 to E20)

fe. Watch (C2) Cartier Watch Design from 2009 (D2) 500,000 Dollar (E1)


and I want to automatically use sheet 2 for the invoice

Sheet 2 - Invoice

This time I want to make A10 to A30 a dropdown list. The dropdown list is the list from the 1st sheet (Name)

Is it possible to automatically put the matching description and price in B10 and C10 (when you choose a random item in the dropdown list)?

Thank you

Thank goodness. I was lost and not much help.