Find and Replace across spreadsheets

[robwlinder]

I am a newer user to spreadsheets, and have only basic knowledge of how to use such as formulas and referencing individual cells into a formula. My current task at hand is updating a spreadsheet I have. It was downloaded online as a base to work off of, but is very out of date. The spreadsheet is a list of items within a game, Eve Online. The spreadsheet currently functions just as it should, but the listed items are simply out of date. I currently have the entire set of data that i need to update the spreadsheet, however this is where the problem starts.

The information I need is spread between three sheets. One sheet (Sheet A) is to be used as a reference sheet listing the actual Item Name and it's typeid#. In this sheet the item names are listed in one column and the typeid# is listed in the next column. I have a seperate spreadsheet (Sheet B) which contains a list of certain items out of this that can be reprocessed. The items in this list are listed by their typeid# and not their name.

The question is, how do I get the typeid# column from Sheet B to use Sheet A as a reference to replace the typeid#'s with their item name equivalents?

Thanks for any help you can offer

[Russell Dawson]

This Forum is for users of Excel. There is a similar forum for users of Open Office which would be more appropriate in your case.

[Firefly2012]

Hi

VLOOKUP or INDEX/MATCH should work equally well in versions of OpenOffice as they do in Excel. The format of the function will be along the lines of:

=VLOOKUP(SheetB!A2,SheetA!A:B,2,0)

assuming that the order of columns if TypeID# then Description in SheetA or:

=INDEX(SheetA!A:A,MATCH(SheetB!A2,SheetA!B:B,0))

if Description then TypeID#

[robwlinder]

Thanks much Firefly for the help. That's all I needed was a start. I appreciate it.

[darknation144]

Please mark this as solved if you have received a satifactory solution.

[robwlinder]

Done and once again, Thanks for the help all.