If Column A says "yes" enter the value in Column B into Column C

**ykreitz** · 06-27-2018, 07:48 PM

Appreciate some help. I have a drop down selection in Column A for conference registration: "1 = Required" "2 = Should go" and "3 - Nice to have." Column B has a dollar amount for the conference. It's a long list, and sorting is a pain since we can change the classifications. Column B is good for the cumulative total. I'd like to have three breakdown columns for Required, Should Go, Nice to Have, that I can then total separately. So In essence, if column a says "1 = Required," then populate the value in Column B into Column C.

Can you help?

**FDibbins** · 06-27-2018, 07:54 PM

Hi, welcome to the forum

Based on your heading....

C1=if(A1="1 = Required",B1
Just watch the spelling and spaces

**ykreitz** · 06-27-2018, 07:58 PM

You Rock! It Works!!!!

**FDibbins** · 06-27-2018, 08:11 PM

Happy to help

If Column A says "yes" enter the value in Column B into Column C

LinkBack

Thread Tools

Rate This Thread

Display

If Column A says "yes" enter the value in Column B into Column C

Re: If Column A says "yes" enter the value in Column B into Column C

Re: If Column A says "yes" enter the value in Column B into Column C

Re: If Column A says "yes" enter the value in Column B into Column C

Thread Information

Users Browsing this Thread

Similar Threads

Highlight column "due date" when passed but not if column "status" says "complete"

[SOLVED] Prevent Duplicate Receipt Number in Three Column [ e.g. Column "A", "B", "C" ]

Display in a column of "sheet_01" all the data of any column of a "sheet_02". My "sheet_2"

[SOLVED] Macro To Look at list of files in column "A" and show their last Saved Date in Column "B"

Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

Enter a formula in column A, if a condition in column "B" is met

Bookmarks

Bookmarks

Posting Permissions