Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# HOW TO DO THIS IN EXCEL

EXCEL FORMULA

Best Answer JoMalig , 29 March 2022 - 03:26 AM

Hi, It works for me including on Google Sheets!  It worked. Thank you so much. The problem why it didn't work the first time was because of the semicolon ;   it should... Go to the full post »

### #1 JoMalig Posted 16 March 2022 - 06:21 AM

JoMalig

Member

• Member
• 46 posts

Hello,

I just want to ask how to do this in excel or rather what formula I will use? Please see image below;

In cell A3, if I put a number equal to any of the numbers under E column then it will show the word SUBMITTED in cell B3.

If the number I put in cell A3 is equal to any of the numbers under F column then it will show the word PENDING in cell B3.

If the number I put in cell A3 is equal to any of the numbers under G column then it will show the word FINISHED in cell B3.

If the number I put in cell A3 is not equal to any of the numbers under column E, F and G, then B3 will remain blank.

• 0

### #2 nasdaq Posted 16 March 2022 - 09:17 AM

nasdaq

Visiting Staff

• Visiting Consultant
• 166 posts
Hello, Welcome to MALWARETIPS.
I'm nasdaq and will be helping you.

If you can please print this topic it will make it easier for you to follow the instructions and complete all of the necessary steps in the order listed.
===

The IF statement is well explain in this topic.

Hope that helps.

• 0

### #3 SleepyDude Posted 16 March 2022 - 10:51 AM

SleepyDude

Trusted Helper

• Malware Removal
• 4,953 posts

Hi,

Check if this works for you!

on B2 to check value from A2

=IF(COUNTIF(E:E;A2)>0;E1;IF(COUNTIF(F:F;A2)>0;F1;IF(COUNTIF(G:G;A2)>0;G1;"")))

• 0

### #4 JoMalig Posted 25 March 2022 - 04:38 AM

JoMalig

Member

• Topic Starter
• Member
• 46 posts

Hello, Welcome to MALWARETIPS.
I'm nasdaq and will be helping you.

If you can please print this topic it will make it easier for you to follow the instructions and complete all of the necessary steps in the order listed.
===

The IF statement is well explain in this topic.

Hope that helps.

Thanks for the welcome

Sorry but it did not explain what to do in my case. But thanks anyway.

Hi,

Check if this works for you!

on B2 to check value from A2

=IF(COUNTIF(E:E;A2)>0;E1;IF(COUNTIF(F:F;A2)>0;F1;IF(COUNTIF(G:G;A2)>0;G1;"")))

Sorry, It didn't work.

• 0

### #5 SleepyDude Posted 26 March 2022 - 10:22 AM

SleepyDude

Trusted Helper

• Malware Removal
• 4,953 posts

Hi,

It works for me including on Google Sheets!

• 1

### #6 JoMalig Posted 29 March 2022 - 03:26 AM

JoMalig

Member

• Topic Starter
• Member
• 46 posts

Hi,

It works for me including on Google Sheets!

It worked. Thank you so much.

The problem why it didn't work the first time was because of the semicolon ;   it should be comma.

• 0

### #7 SleepyDude Posted 29 March 2022 - 06:44 AM

SleepyDude

Trusted Helper

• Malware Removal
• 4,953 posts

The use of ; or , in Excel depends on the Operating System Regional Settings, for me its ;

It seems that Google Sheets uses , and did automatically adjusted the pasted formula.

• 0

### #8 JoMalig Posted 01 June 2022 - 06:05 AM

JoMalig

Member

• Topic Starter
• Member
• 46 posts

I see. I didn't know that. that's new to me

Thanks again mate.

• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users