Locum - multiple If Statements

[skyhigh_ct]

Looking to output column "D" Render. Thank you
A B C D
1 DR LOCUM MOD Render
2 smith jack Q6 jack
3 smith (blank) Q6 error
4 smith smith Q6 error
5 smith smith "<>Q6" smith
6 smith (blank)"<>Q6" smith
7 tom tom "<>Q6" tom
8 tom (blank) "<>Q6" tom
9 tom ralf Q6 ralf
10 tom (blank) Q6 error
11 tom tom Q6 error

 

[mrmmickle1]

This looks like gibberish please be more specific. Usually a before and after result can be helpful.

 

[skyhigh_ct]

I was tired last night, & my pasting of a grid did not format properly.
I am not sure how to upload a picture or spreadsheet from PC (perhaps not allowed?).

Goal is to return a name or "error" in column D. [note "Q6" is text, not a cell reference]

First if/and condition: if data in column "C" is = "Q6", populate column "D" with column "B" value if "B" is not blank, if "B" is blank, return "error";
Second condition: if/then column "C" is <> "Q6", populate column "D" value when column "B" has name, if "B" is blank, populate with column "A" value

Thank you very much for helping. - Jason

 

[Fluff]

Is this what you want
Excel 2013 32 bit

	A	B	C	D
DR	LOCUM	MOD	Render
smith	jack	Q6	jack
smith	Q6	error
smith	smith	Q6	smith
smith	smith	Q7	smith
smith	Q7	smith
tom	phil	Q7	phil
tom	Q7	tom
tom	ralf	Q6	ralf
tom	Q6	error
tom	tom	Q6	tom

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(C2="Q6",IF(B2<>"",B2,"error"),IF(C2<>"Q6",IF(B2<>"",B2,A2)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[skyhigh_ct]

Very Close but,
Row 4 & 11 would need to yield an error because (1st argument) when column "C" is = Q6, & the names in column "A" & "B" are the same.

Thank you very much for the feedback.

 

[Fluff]

How about
Excel 2013 32 bit

	A	B	C	D
DR	LOCUM	MOD	Render
smith	jack	Q6	jack
smith	Q6	error
smith	smith	Q6	error
smith	smith	Q7	smith
smith	Q7	smith
tom	phil	Q7	phil
tom	Q7	tom
tom	ralf	Q6	ralf
tom	Q6	error
tom	tom	Q6	error

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(C2="Q6",IF(OR(B2="",B2=A2),"error",B2),IF(C2<>"Q6",IF(B2<>"",B2,A2)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]