IF b = Matches then type a word in c

**m_789** · 05-01-2014, 05:12 AM

So..

if b1 = 1 then paste adam in c1
if b2 = 7 then paste kris in c2
if b3 = 3 then paste scott in c3
if b4 = 6 then paste jamie in b4

and so on...

**Sam Capricci** · 05-01-2014, 05:23 AM

Your request is not clearly defined. For example are you wanting ONE formula that incorporates all those or do you just want, for example in C1 =IF(B1=1,"adam","")? then in C2 =IF(B2=7,"kris","") etc
And the "and so on" leaves me wondering if we are supposed to guess at the pattern you are trying.
A possible better route might be to put a small table elsewhere and do a vlookup against it.

**m_789** · 05-01-2014, 05:26 AM

Okay, sorry.

So basically lets just stop it at b4

so it does the following

if b1 = 1 then paste adam in c1
if b2 = 7 then paste kris in c2
if b3 = 3 then paste scott in c3
if b4 = 6 then paste jamie in b4

no pattern required

**Sam Capricci** · 05-01-2014, 05:32 AM

do you want a group of embedded ifs? this would be the embedded formula for all beginning in C1 =IF(B1=1,"adam",IF(B1=7,"kris",IF(B1=3,"scott",IF(B1=6,"jamie",""))))

**Sam Capricci** · 05-01-2014, 05:33 AM

If your only options are those four and you don't want blanks then you would use this…
=IF(B1=1,"adam",IF(B1=7,"kris",IF(B1=3,"scott","jamie")))

**m_789** · 05-01-2014, 05:40 AM

thank you :-)

IF b = Matches then type a word in c

LinkBack

Thread Tools

Rate This Thread

Display

IF b = Matches then type a word in c

Re: IF b = Matches then type a word in c

Re: IF b = Matches then type a word in c

Re: IF b = Matches then type a word in c

Re: IF b = Matches then type a word in c

Re: IF b = Matches then type a word in c

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] find word(s) within text string that matches a list of keywords

[SOLVED] find first word within text string that matches from a list of keywords

Find value closest to another value using type 0 and 1 matches at the same time

[SOLVED] Excel will not let me type any characters....I can type in Word.

[SOLVED] Excel will not let me type any characters....I can type in Word.

Bookmarks

Bookmarks

Posting Permissions