MrExcel Publishing
Your One Stop for Excel Tips & Solutions

one more question please


Posted by AMBER on February 15, 2002 12:39 PM

Dreamboat, your suggestion worked wonderfully, thank you very much.... my next question is this.... in that same column (d) i want it to look for different numbers and depending on the number put catalyst 3500 series in row c or vg200 in row c...
ie... column d has model # ws-c3512-xl-en... column b now has cisco in it because of the ws... i would like column c to have catalyst 3512 because of the c3512 portion of the model number...

i didn't understand what the leftd2,2 statement meant but it worked so i'm grateful!!

thanks again, Amber


Posted by Dreamboat on February 15, 2002 1:47 PM

First, Amber, you might be doing this in a harder manner than necessary.

You might ought to be using the VLOOKUP function.

=left(d2,2) returns the first two characters of the cell D2.

However, if you've got a number of variables (ws=cisco, ab=mickey, cd=minnie, etc.), then you might want to make yourself a vlookup.

You can email me for a sample VLOOKUP file.
dreamboat@nni.com