Formula(s) to populate cells based on several criteria

**christopherparrish** · 03-28-2024, 08:33 AM

I tried to search for this solution, but wasn't able to find it and I'm not even sure if I'm asking this the right way.

I have a spreadsheet with an Employee ID column (Column B) and an Email address column (Column C). Not all users have an Employee ID, contractors only have an Email address, so I want to combine columns B and C in to column D. The caveat is column B has blanks, where the user is a contractor, but column C also has blanks. When I use this formula to combine them it works, except in the cases where there is an EID in column B and EMail in column C, it throws a "False" in the column D cell. =IF(C2="",TEXT(B2,"000000000"),IF(B2="",C2)). I have to format column B to provide the leading zeroes for the EID.

Here's a sample of what I'm looking at.

ExcelHelp.png

Any help will be greatly appreciated!

**AliGW** · 03-28-2024, 08:40 AM

Welcome to the forum.

What do you want in that column if BOTH columns are filled out?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**AliGW** · 03-28-2024, 08:42 AM

Try this:

=IF(C2="",TEXT(B2,"000000000"),IF(B2="",C2,TEXT(B2,"000000000"))

**Pete_UK** · 03-28-2024, 08:45 AM

You haven't included a value_if_false clause for the IF functions. Perhaps you need something like this:

=IF(B2="","",TEXT(B2,"000000000 ")&C2

Hope this helps.

Pete

**christopherparrish** · 03-28-2024, 08:48 AM

HOLY COW, that worked!!! What really stinks is I was so freaking close to getting to that formula last night, but after a 12 hour day of Excel and ELT preso prep I was mentally done.

Thank you so much!!!

**AliGW** · 03-28-2024, 08:53 AM

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Formula(s) to populate cells based on several criteria

LinkBack

Thread Tools

Rate This Thread

Display

Formula(s) to populate cells based on several criteria

Re: Formula(s) to populate cells based on several criteria

Re: Formula(s) to populate cells based on several criteria

Re: Formula(s) to populate cells based on several criteria

Re: Formula(s) to populate cells based on several criteria

Re: Formula(s) to populate cells based on several criteria

Thread Information

Users Browsing this Thread

Similar Threads

populate cells based on multiple criteria

Populate data to one sheet from another and a formula to fill cells based on criteria.

[SOLVED] Help to automatically populate cells based on criteria

[SOLVED] Auto Populate Cells Based on a Criteria

Populate cells based on 3 criteria.

Using VBA to populate cells based on a criteria in another tab

[SOLVED] Populate Cells based on Criteria of Another Cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions