Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to find if an array c10 thru g10 contains a number, then return either a X or leave it blank
Solved by C. W. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 31/03/2018 - 06:08
Hi there
User 31/03/2018 - 06:08
Hi
Excelchat Expert 31/03/2018 - 06:08
How are you and how may i assist you with today?
User 31/03/2018 - 06:10
OK, Column a thru say e, each line has an array of number from 1 thru 20: I want to put 1 thru 10 on line 1, columns g------: I want to be able to say is 6 in the array (a - E),, if so, then return an "x" if not leave blank
Excelchat Expert 31/03/2018 - 06:10
Okay, i will try my best to help you out with this
Excelchat Expert 31/03/2018 - 06:10
Can you share me a sample worksheet
Excelchat Expert 31/03/2018 - 06:10
So that we both can have a better evaluation to the issue
User 31/03/2018 - 06:10
can I type on the spread sheet on the screen
Excelchat Expert 31/03/2018 - 06:10
Yep sure
User 31/03/2018 - 06:13
So ..... I want the x in the 2, (h column), also the 16, 18 and 7, but not in the 1, 3 or 5
Excelchat Expert 31/03/2018 - 06:14
Okay so what would be the criteria for that?
User 31/03/2018 - 06:14
I have about 150 lines, and I need to see a representation of the patter going down - at a glance
User 31/03/2018 - 06:14
sorry, pattern
Excelchat Expert 31/03/2018 - 06:15
On what criteria we shall have those X to put up
User 31/03/2018 - 06:15
I'm sorry I don't understand your question
Excelchat Expert 31/03/2018 - 06:16
based on some fixed numbers like 2,4, 7 we shall get X? or how should the X come in?
Excelchat Expert 31/03/2018 - 06:17
pattern in the sense are those prime numbers?
User 31/03/2018 - 06:17
I want to say that the Number 5, 2, 16, 18 and 7 are x's. Then again I want to be able to see when those number would repeat....is taking 2: it repeats on line 6, lin 20, line 23, 24 and 50
User 31/03/2018 - 06:19
That formula doesn't work, it's not putting an "x in the column "H" and nothing in colum "g"
Excelchat Expert 31/03/2018 - 06:19
M not able to get it, can you be more specific step by step
Excelchat Expert 31/03/2018 - 06:21
Means If H3 is X then in B4 you want to see X?
User 31/03/2018 - 06:21
OK. I want to look at the array on line 3: we have a 5, 2, 16, 18 and 7: I want an X under the columns K, H, M etc..., then on line 4, I want to do the same with the next set of numbers
Excelchat Expert 31/03/2018 - 06:22
Okay, i think i got it now
User 31/03/2018 - 06:22
OK
User 31/03/2018 - 06:25
Do I use the "match" function? If so, how do I make that formula say X in the appropriate column and leave the other blank?
Excelchat Expert 31/03/2018 - 06:26
Will get you the appropriate formula, just give me a while
User 31/03/2018 - 06:26
OK - thanks
Excelchat Expert 31/03/2018 - 06:31
Hey
User 31/03/2018 - 06:31
hello
Excelchat Expert 31/03/2018 - 06:31
Its done
Excelchat Expert 31/03/2018 - 06:31
:)
User 31/03/2018 - 06:32
OK, how do I do this?
Excelchat Expert 31/03/2018 - 06:32
will share you the sheet shortly
User 31/03/2018 - 06:32
ok
Excelchat Expert 31/03/2018 - 06:36
Please have a look
[Uploaded an Excel file]
Excelchat Expert 31/03/2018 - 06:36
is it nice
User 31/03/2018 - 06:36
Looks great - I'll try it - thanks so very much. I appreciate your help. Have a great day
Excelchat Expert 31/03/2018 - 06:37
Please do a valuable rating for me
Excelchat Expert 31/03/2018 - 06:37
that will help me a lot
User 31/03/2018 - 06:37
OK will do....ciao,
Excelchat Expert 31/03/2018 - 06:38
If you really like it then please put up some good words, for me :)
Excelchat Expert 31/03/2018 - 06:38
Thanks for being in Got it Pro!
User 31/03/2018 - 06:39
where do I put the "comments"
Excelchat Expert 31/03/2018 - 06:39
Have a nice day!
Excelchat Expert 31/03/2018 - 06:39
After you click on end session
Excelchat Expert 31/03/2018 - 06:39
you will get the options :)
Excelchat Expert 31/03/2018 - 06:40
Are you there?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Trusted by people who work at