Search results

I'm Mark from Portland, OR. This site is fantastic. Sign up for the newsletter because you'll get some great tips and tricks that are useful for those who work in Excel. I hope I can contribute something down the line because as of now, I'm just taking! Thanks to everyone for making this a...

@shrivallabha - indeed it does! Thanks for passing this along! @Montrey - it definitely is. Invaluable formula.

Will do Sir, and again, I appreciate your help. I'll download that file soon, but now I should actually do some work! Thanks again!! Mark

@Sir I appreciate your help. It looks like the formula almost work but if you notice the first three columns did not produce a name in the yellow fields. I figure this is because the code it's trying to retrieve is the last thing in the cell and thus, not separated by a comma. @Narayan - This...

Answers: A) no it's not the entire list B) Name X - in row 3 it should produce CAV in Column B (the attributes column will only have one of the attributes listed in column I) C) When I was trying to use the original formula, it would see the RES code and insert RE (that could be my error though)

Okay, thanks a bunch. Unfortunately I'll be leaving for a few hours here shortly but I really appreciate your help and willingness to look at this. Mark

Sorry, how about now?

I'm looking for something that will search in the attribute column and produce the full name of the code in the next column over. I have a list of attributes that can be in the Attribute column. The issue I run into is when two codes are similar (RE and RES) in the attribute column but they...

Thanks sir, it's more about wanting to do it myself but I'll review the acceptable ways to upload a file and upload it for the group. Mark

I'm still working on this but haven't gotten the results I need. I'm tweaking the formula to try to solve it myself. I have a similar request as the one above except that I'm searching for codes and some codes are very similar: A few examples of codes: RE RES SCH CAV I'll upload a file...

Sorry to jump in but I had a question on this too. This almost worked for me but what I run into when there are two similar names but I need it to treat them separately. In RMajare's example, what would happen if one cell had Hans but another cell had Hansel. Or Rob & Robert? Thanks!