Question on a macro or function statement

[TomExcelMon]

Hi Everyone,

I'm currently trying to make a macro or an if function that see if Column A has Ru-barb and if it does to put Pie into Column C. Also if Column A has Baked to put into Column C Brownies. Does anyone know of a macro that can accomplish this task or something similar? Thank you for your time in advance.

From:

Ru-barb
Baked

To:

Ru-barb		Pie
Baked		Brownies

[Mad-Mizer]

Something like

Please Login or Register  to view this content.

Should work.

[TomExcelMon]

Is there anyway to make it column specific instead of one cell? Lets say I have a random list of these items in a jumbled order.

[Mad-Mizer]

Take that formula and copy down. I placed that formula in C1 and copied it down to C10 and it checked all those in A from A1 to A10. Is that what you mean?

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[MrShorty]

the IF() function is adequate when you have a few choices to make. This sort of thing seems to me like it can expand pretty quickly. If I am correct in that, you may want to consider building a lookup table and using one of Excel's lookup() functions (VLOOKUP() for example https://support.office.com/en-us/art...rs=en-US&ad=US ) rather than a long string of nested IF() functions.

[TomExcelMon]

Thank you John. I apologize ahead of time for not explaining the task further, I need it to also search for cells that have a likeness to Ru-barb, such as Hot Ru-barb, Steamy Ru-barb, etc. to then return pie in the third column.

[TomExcelMon]

Yes Mad-Mizer, that's what I want to have happen. Also for likenesses to be compared such as search for Hot Ru-barb to return pie to both of those rows that contain Ru-barb.

[JOHN H. DAVIS]

Thank you John. I apologize ahead of time for not explaining the task further, I need it to also search for cells that have a likeness to Ru-barb, such as Hot Ru-barb, Steamy Ru-barb, etc. to then return pie in the third column.

Try:

Please Login or Register  to view this content.