If Formula

Alaska1 · #1 10-09-2018, 03:11 PM

I have data that is in an excel file

Some rows have data and some rows are blank.

Asset Field
Blue; Red; Yellow
Blue
Yellow
Red

I want to add Brown to all those rows including the blank ones.

I tried an IF statement and it did not work. What is the best formula to use?

jeffreybrown · #2 10-09-2018, 07:32 PM

Quote:

Originally Posted by Alaska1

I have data that is in an excel file

Then how about attach that sheet to the Forum here and have a clear before and after picture of what you want to achieve.

Alaska1 · #3 10-10-2018, 02:43 AM

Attach see file

Alaska1 · #4 10-10-2018, 03:33 AM

Use this file. Thank you for your help.

jeffreybrown · #5 10-10-2018, 04:13 AM

Put this in B2 and copy down...

=IF(A2="","Brown",IF(ISNUMBER(SEARCH("Brown",A2)), A2,A2&"; Brown"))

Alaska1 · #6 10-10-2018, 02:59 PM

Thank you so much it worked perfect.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
IF(OR - IF(AND // Formula Help	Pixie	Excel	2	09-06-2017 11:12 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
formula	rolyreefer	Excel	1	03-14-2016 08:36 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM