[JoMalig]

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.

 

Thanks in advance.

 

[Advertisements]

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.

 

https://support.micr...bc-aa8bbff73be2

 

Hope that helps.

[nasdaq]

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.

 

https://support.micr...bc-aa8bbff73be2

 

Hope that helps.

[SleepyDude]

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;"")))

[JoMalig]

 

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.

 

https://support.micr...bc-aa8bbff73be2

 

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. 

[SleepyDude]

Hi,

 

It works for me including on Google Sheets!

 

[JoMalig]

Best Answer

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. 

[SleepyDude]

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.

[JoMalig]

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

Thanks again mate.