Acquiring and importing data from source spreadsheet

[CNR]

Hi all !

I have a source sheet with 3 columns: "Product ID" , "Product description" and "Price".
I need to make another sheet where one will key in the "Product ID" and the sheet will import the corresponding description and price.

Can someone please give me a hint on how it could be done the easiest way ?

I don't know where to start searching, database ? is there a function that could do it ?

Thanks

[RusselB]

A database might not be a bad idea to look at, but if you haven't used them before, the learning curve can be steep.
If you want to keep to Calc, then you're probably looking for the VLOOKUP function.
The VLOOKUP function is the easiest method I'm aware of.

[CNR]

No, i haven't used database before and i was hoping not to have to at this time
can VLOOKUP work with 2 different files ? i.e.: source file and target file ? i was looking at DGET right now, trying to figure out if it can accept a data range from a different file.

thanks !

[RoryOF]

Why not expand the source file to have another sheet, the result sheet?

[CNR]

yeah that's ok. So can VLOOKUP or DGET get the data range from a different sheet ?

[RusselB]

Earlier you said a source sheet, rather than a source file.
If the source file is a spreadsheet, then VLOOKUP can work with a different file.
If the source is not a spreadsheet, then the database functions that are available in Calc may be the way to go.
While you may not need the full database yet, it sounds to me like you might in the future, so it might be a good idea to start reading up on them.

[CNR]

Ok, i'll go with VLOOKUP then.

I know you're right about the database, it's on my to do list but most likely next month when i'll have enough spare time from work.

Thank you both very much

[Villeroy]

If the source file is a spreadsheet, then VLOOKUP can work with a different file.
If the source is not a spreadsheet, then the database functions that are available in Calc may be the way to go.

https://libreoffice.org can do the trick with csv files as well. It prompts for import options when refreshing the link.