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
1	DR	LOCUM	MOD	Render
2	smith	jack	Q6	jack
3	smith		Q6	error
4	smith	smith	Q6	smith
5	smith	smith	Q7	smith
6	smith		Q7	smith
7	tom	phil	Q7	phil
8	tom		Q7	tom
9	tom	ralf	Q6	ralf
10	tom		Q6	error
11	tom	tom	Q6	tom

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =IF(C2="Q6",IF(B2<>"",B2,"error"),IF(C2<>"Q6",IF(B2<>"",B2,A2))) <tbody> </tbody>

<tbody>
</tbody>

 

[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
1	DR	LOCUM	MOD	Render
2	smith	jack	Q6	jack
3	smith		Q6	error
4	smith	smith	Q6	error
5	smith	smith	Q7	smith
6	smith		Q7	smith
7	tom	phil	Q7	phil
8	tom		Q7	tom
9	tom	ralf	Q6	ralf
10	tom		Q6	error
11	tom	tom	Q6	error

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =IF(C2="Q6",IF(OR(B2="",B2=A2),"error",B2),IF(C2<>"Q6",IF(B2<>"",B2,A2))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>