Can the VLOOKUP function auto fill multiple cells from a single reference?

No it is not possible. You have to copy the formula in A2, A3, and A5 separately and just change the index number, to get the relevant information from the other place.

If the column on the two side of the date column (or the two facets) is crammed down so a procedures as you prefer the dates, basically hover over the decrease precise corner of the 1st date cellular (when you have entered the 1st date) and once you get the black circulate, double-click. it's going to vehicle-fill as a procedures as a results of fact the column alongside it truly is crammed. in case you do it on a column this is already crammed, yet you adjust the fee, it's going to vehicle-fill to the final used row in that column. in case you prefer to fill a column with the same extensive style, or with a extensive style this is not sequential (say the subsequent 20 Monday dates) form interior the 1st 2 values, spotlight them, and vehicle-fill (double-click) from the decrease-precise corner of the two-cellular block. you're able to do the same element horizontally, yet you ought to drag, you won't be in a position to double-click. (you are able to drag an entire column to the left or precise.) vehicle-filling text fabric will basically supply you the same text fabric in all the automobile-crammed cells. Incrementing or decrementing in basic terms works with numbers and dates (that are saved internally as numbers).

A VLOOKUP function can only return data in the cell in which it resides.