#1
|
|||
|
|||
Assistance with formula please
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 |
#2
|
|||
|
|||
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 Code:
=OldSheet!$A2 & OldSheet!$D2 & OldSheet!$G2 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 |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Thanks for the replies. I ended up entering the data manually, so will mark this thread solved.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Assistance - Format Change using Formulae | EJohnB | Excel | 5 | 07-09-2019 03:30 PM |
Formula Assistance Required | mfolland | Excel | 1 | 04-16-2019 05:21 PM |
Need assistance with multiple IF argument formula | Btrrcup610 | Excel | 1 | 02-25-2016 11:14 AM |
Assistance with Word 2010 If formula | ciresuark | Word | 1 | 03-09-2015 12:57 PM |
Formula assistance please | blazzercat | Excel | 2 | 07-08-2009 08:45 AM |