'How to use autofill in Google Sheet formula?

I have formula to auto fill data like column A. It is no need to hand dragging or auto filling by suggestion.

enter image description here

Here column A is perfectly done. Cell A1 formula as below:

={ "VendorNo"; unique(General!A2:A) }

Cell B1 formula is correct as below:

LOOKUP(VendorStatus!A2,sort(General!A2:A),sort(General!C2:C,General!A2:A,TRUE))

Once cell A1 is done, all A column is real auto filled. All I want is to do is the same effect like cell A1. How can I rewrite B1 formula to auto filled the rest B column value?

P.S.: I am sorry I couldn't post image above directly because I don't have enough reputation.

google-sheets

Solution 1:^[1]

try in row 1:

={"event start date"; INDEX(IFNA(VLOOKUP(A2:A, General!A2:C, 3, 0)))}

or:

={"event start date"; INDEX(IFNA(VLOOKUP(A2:A, 
  SORT(General!A2:C, ROW(General!A2:C), 0), 3, 0)))}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1

'How to use autofill in Google Sheet formula?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]