Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account

# 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,970 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,970 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,970 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