Assign a value(s) based on the content of a cel?

**JohnTopley** · 04-20-2017, 05:10 PM

Is formula #1 not ....

=RIGHT(A2,2)

101=(0)1, 110=10, 136=36

**bool** · 04-24-2017, 01:28 PM

Yes, formula #1 works with 2 digits. Thank you so much. Formula #2 works but on the categories with 10 levels I had to make some adjustments, eg. =RIGHT(A2,1)+1 for section 140, level 1 expert (section 149 would be level 10). Thank you all!

**JohnTopley** · 04-24-2017, 01:34 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Assign a value(s) based on the content of a cel?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Assign a value(s) based on the content of a cel?

Re: Assign a value(s) based on the content of a cel?

Re: Assign a value(s) based on the content of a cel?

Thread Information

Users Browsing this Thread

Similar Threads

Assign a value to a cell based on a portion of the content of another cell

Automatically copy cells content based on the content of another cell.

[SOLVED] SUMIFS/INDEX/MATCH--looking to assign array based on Prod description & date to assign qty

[SOLVED] assign cell content to variable

Select data based on content, cut content, and move to new cell

[SOLVED] Assign Cell Content As File Name

[SOLVED] assign cell content as file name

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions