Help with spreadsheet formula

[ButterflyEffects]

Good afternoon,
I'm trying to figure out how to do the following:

Basically column A contains a list of categories. Column B needs to be the eBid category and column C needs to be the shop category.

So the formula would need to basically pick a row of items, from another spreadsheet, to automatically complete eBid and shop category.

I hope that makes sense, and if there's an spreadsheet expert out there -please help me
Many thanks
Patrick

[astral276]

I can do it for another sheet within the same workbook. I don't know if that would work across workbooks.

To copy cell B10 from SheetA to SheetB the function in the destination cell on SheetB is:

='SheetA'!$B$10

[ButterflyEffects]

Hiya,
I can do that, and that can be done across spreadsheets
What I really need is for the formula to read the contents of a cell (e.g. Paythings/Stuff) then look at Column A of 'Categories' spreadsheet, read Column B and Column C and then input them into the original spreadsheet.
Basically it's so I can upload 4,500 items to eBid without having to manually select the correct category for about 500 categories of items
Any help would be marvellous, as I'm stuck
P

[illudius]

If I'm understanding it right you could probably use MATCH and INDEX.

The below finds the value in Cell F1 in column A and then returns the value in corresponding row from Column B.

=INDEX(B:B,MATCH(F1,A:A,0))

If you doing it across spreadsheets you'd have to change the cell references to include the spreadsheet name.

Hope this helps,
Illudius