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