**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.*