• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Trying to paste a column on the left and automatically place a category to right

R

RadMan

New Member
Hi,

I've looked all over for an answer for this and can't find any. I'm not sure it can be done. Here's and example. On the right i'm trying to come up with a formula that looks to the name on the right and puts a category name on the right of it such as Automobile and Groceries.


https://docs.google.com/spreadsheet/ccc?key=0ApSSl6J2T3N7dGFxM1JNakhNWkhjN01qbG9oRkEtU1E


Thanks for taking a look.

Mark
 
Radman


You might want to look at using the Index/Match combo


Have a look here: https://www.dropbox.com/s/xaoyxl2ggyid3c5/Changenameeg_1.xls
 
You must log in or register to reply here.
Back
Top