Hi all



I have a spreadsheet with text in multiple cells in Column B, sorted alphabetically.
Earlier in the spreadsheet the same information is listed in Column B, however it is sorted by Category, with the Category name in either Column A, D or G.

What I would like to do is have the alphabetically sorted text search for it's exact match in the category sorted text earlier in the spreadsheet, and return the text that is in Column A, D or G, into the relevant cell to the left of the text (which will also be in column A, D or G, but in the alphabetically sorted section).

Is that doable, and if so, what would the formula look like?

Thanks so much for your assistance

Sue

Lets's see did I understood this:
You had a sheet in your workbook, with some table on sheet with some entries in column B. In same table, you had 3 different columns (A, D, and C) which contained category information about entry in same row.
Was there always a single category entered for entry into one of 3 category columns (leaving cells in other columns empty), or could an entry have up to 3 different categories?

Now you added another sheet and table, with copy of entry column B of earlier table in column B of new table. And you want category info from earlier table displayed in column left of column B in new table (obviousluy in column A of new table).

Now when in earlier table for every entry is only one category (or none), it will be easy. E.g. into cell A2 in new table you enter the formula like
, and copy it down.

When there may be several different categories in previous table for same entry, you have either make some decision the category from which column you prefer {e.g. implementing nested IF()'s}, or you have to redesign your new table so it will have a row to every different category entered into earlier table for this entry. And you have to implement more complex formula into new table and probably some helper column(s) like row numbering into older table!

The 3rd option is - I didn't understood anything

Please post a sample sheet with some data and some manually added results. Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for the replies. I ended up entering the data manually, so will mark this thread solved.