How to Fill a Column C based on text in Column A and B

[raghuram.star]

Hi I need your help to Fill/Assign a value in Column C based on text in Column A and B

Logic to fill "Direct/InDirect" in Column C if Column A contains text "Overhead" or Column B contains "TAG"

Sample Table will look like below

Column A	Column B	Column C
Project 1 Requirements	ELE X	Direct
Project 1 Development	ELE X	Direct
Project 1 Review	ELE X	Direct
Project 1 Overhead	ELE X	InDirect
Project 2 Requirements	ELE Z	Direct
Project 2 Development	ELE Z	Direct
Project 2 Review	ELE Z	Direct
Project 2 Overhead	ELE Z	InDirect
Project 1 Requirements	TAG Y	InDirect
Project 1 Development	TAG Y	InDirect
Project 1 Review	TAG Y	InDirect
Project 1 Overhead	TAG Y	InDirect
Project 3 Requirements	ELE W	Direct
Project 3 Development	ELE W	Direct
Project 3 Review	ELE W	Direct
Project 3 Overhead	ELE W	InDirect

<tbody>
</tbody>

Please help me...

 

[Arjan77]

Paste this formula in cell C1 and drag it down:

=IF(OR(ISNUMBER(SEARCH("Overhead",A1)),(ISNUMBER(SEARCH("TAG",B1)))),"InDirect","Direct")

 

[raghuram.star]

Hi Arjan, Thanks for the reply.
But I am looking for a solution in Access!
I am wodering if there is an equivalent to it in Access. Any suggestions?

 

[Arjan77]

Excuse me I didn't notice you asked the question for acces, in that case I have no solution for you unfortunately.

 

[alansidman]

Create a query using the following SQL statement

SELECT Sheet1.Field1, Sheet1.Field2, IIf(InStr(1,[Field1],"Overhead")>0 Or Instr(1,[Field2],"TAG"),"Indirect","Direct") AS Field3FROM Sheet1;

 

[Joe4]

But I am looking for a solution in Access!

What may have also led to the confusion is terminology. Column A, B, and C are distinctly Excel terms.
Excel has "columns and rows" while Access has "fields and records".

 

[raghuram.star]

Create a query using the following SQL statement

SELECT Sheet1.Field1, Sheet1.Field2, IIf(InStr(1,[Field1],"Overhead")>0 Or Instr(1,[Field2],"TAG"),"Indirect","Direct") AS Field3FROM Sheet1;

Thank you Alan Sidman

 

[raghuram.star]

What may have also led to the confusion is terminology. Column A, B, and C are distinctly Excel terms.
Excel has "columns and rows" while Access has "fields and records".

Oops... I missed that part, Thanks for letting me know... I used to work with Excel and recently got work with Access and learning it!

 

[Joe4]

Oops... I missed that part, Thanks for letting me know... I used to work with Excel and recently got work with Access and learning it!

No problem! I figured you were probably an Access noob, so just trying to help you learn the terminology to help reduce confusion going forward.