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
[Uploaded an Excel file]
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.