Insert numbers into the respective date

[Soleblue]

Good evening guys,
could you help me with a formula (or with vba) to put the numbers of column G in the corresponding days of column B?
I don't remember anything anymore

Thanks a lot

 

[ETAF]

try
=INDEX($G$2:$G$1000,MATCH(A2,$F$2:$F$1000,0))

copy down -

maybe add an IFERROR()

=IFERROR(INDEX($G$2:$G$1000,MATCH(A2,$F$2:$F$1000,0)),"")

what version of excel do you have
xlookup() would work
=XLOOKUP(A2,$F$2:$F$1000,$G$2:$G$1000,"")

filter()

 

[vletm]

or ...
cell B2 =IFERROR(INDEX(G2:G89,MATCH(A2:A367,F2:F89,0)),"")

 

[Soleblue]

Hi guys,
neither of the 2 works, if I'm not mistaken
I use 365 (Italian)
so I have to translate the formulas and instead of "." I think I have to use ";" , correct?

 

[vletm]

Instead of "," use ";"

 

[Soleblue]

try
=INDEX($G$2:$G$1000,MATCH(A2,$F$2:$F$1000,0))

copy down -

maybe add an IFERROR()

=IFERROR(INDEX($G$2:$G$1000,MATCH(A2,$F$2:$F$1000,0)),"")

what version of excel do you have
xlookup() would work
=XLOOKUP(A2,$F$2:$F$1000,$G$2:$G$1000,"")

filter()

=XLOOKUP(A2,$F$2:$F$1000,$G$2:$G$1000,"")
this works

 

[ETAF]

glad it works for you now

 

[Soleblue]

Instead of "," use ";"

yes, in Italian I have to replace it, thanks

 

[Soleblue]

Thank you so much for your availability
You are magicians with Excel

 

[vletm]

My sample needs to enter only to one cell - that's all.

 

[p45cal]

Various solutions from other responders in columns B:E. This should translate to Italian formulae when you open it.

 

[Soleblue]

Various solutions from other responders in columns B:E. This should translate to Italian formulae when you open it.

Grazie!!!!! so many interesting things!!!!! very interesting and educational