Excel Multiple value autofill

[rakib.carou]

I am trying to find the excel formula where in Sheet2!A2 (Here-3) is filled any from Sheet1!A, it will give all values from Sheet1!B in Sheet2!B.Capture.JPG

[congnt92]

Try
Sheet 2

Fill down.

[rakib.carou]

Hi, thanks for your reply. Only for 500 rows, it takes huge time with high CPU

[rakib.carou]

Could it be in another way like - Taking the first and last value using VLOOKUP and then generate the middle numbers?

[congnt92]

My test file
Sheet1: 500 rows x 1 col with data
Sheet2: Formula was copied down up to Cell B501
Change the value of cell A2, Excel takes about 2 seconds to display the result.

With big data you may need a vba solution.