# Excel - IF Function Problem - Expert Solution

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

I need a formula that if you imput cell Valuein K39:K124 in D40, L39:039 will populate in E40,F40,G40,H40.
Solved by G. B. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/08/2018 - 08:14
Hi
User 30/08/2018 - 08:14
HELLO
Excelchat Expert 30/08/2018 - 08:15
can you share the excel your working on?
Excelchat Expert 30/08/2018 - 08:15
or a sample
User 30/08/2018 - 08:15
YES
Excelchat Expert 30/08/2018 - 08:16
please do share the excel here using the paper clip symbol
Excelchat Expert 30/08/2018 - 08:20
ok
Excelchat Expert 30/08/2018 - 08:20
i see the data
Excelchat Expert 30/08/2018 - 08:20
i guess you have just pasted the data right
User 30/08/2018 - 08:21
YES'
Excelchat Expert 30/08/2018 - 08:21
what do you mean by D41=K40:K125
User 30/08/2018 - 08:21
i CAN MAKE 1 WORK BUT NOT ALL
Excelchat Expert 30/08/2018 - 08:21
you want to search d41 in k40:k125?
User 30/08/2018 - 08:22
=If(D3=K2,(L2),False)
Excelchat Expert 30/08/2018 - 08:22
ok
Excelchat Expert 30/08/2018 - 08:23
ok then what is the problem with that formula
User 30/08/2018 - 08:24
I wangt D3 to equal K2 thru 20+ so thaty L2<m2,n2,o2 polpulat in e3,f3,g3,h3
User 30/08/2018 - 08:24
It only does 1
Excelchat Expert 30/08/2018 - 08:24
d3=k2 d4=k3 like that?
Excelchat Expert 30/08/2018 - 08:25
L2<m2 they aren't values
Excelchat Expert 30/08/2018 - 08:26
can you show an example of what your expected result would look like without formula
Excelchat Expert 30/08/2018 - 08:27
so all the values from 1-20 you want to input in E3-23
Excelchat Expert 30/08/2018 - 08:28
right?
Excelchat Expert 30/08/2018 - 08:28
you want all data till 20 right
Excelchat Expert 30/08/2018 - 08:29
you there
User 30/08/2018 - 08:29
Yes when you put in the D anyu of the numbers from K ity will givwe you L-O populatrf in E-H
Excelchat Expert 30/08/2018 - 08:29
ok can i make a little modification
Excelchat Expert 30/08/2018 - 08:30
insead of havinf 1-20 can i have it in different columns
User 30/08/2018 - 08:30
yes
Excelchat Expert 30/08/2018 - 08:30
like a1 ans b1 then I can pull the data of anything between that into D-H
Excelchat Expert 30/08/2018 - 08:30
ok
User 30/08/2018 - 08:30
Yes
Excelchat Expert 30/08/2018 - 08:34
change the values in a1 and b1 to update you data
User 30/08/2018 - 08:35
PERFECT !
User 30/08/2018 - 08:35
Thank you
Excelchat Expert 30/08/2018 - 08:36
:) welcome
Excelchat Expert 30/08/2018 - 08:36
:) please do leave a feedback after you end the session
Excelchat Expert 30/08/2018 - 08:36
Have a nice dy
Excelchat Expert 30/08/2018 - 08:36
day
User 30/08/2018 - 08:36
u2

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.