I have a given data columns A,B,C & E. And I tried to write a vlookup formula with autofill function in cell F1 & G1. But I don’t know why F2 & G2 are blanks and move all the results offset 1 cell.
F1 formula:
={ "EventStartDate"; arrayformula(iferror(VLOOKUP(E:E,A$2:B,2,False))) }
G2 formula:
={ "BoothNo"; arrayformula(iferror(VLOOKUP(E:E,A2:C,3,False))) }
Any thoughts to rewrite the formula?
P.S.: I am sorry I couldn’t post image above directly because I don’t have enough reputation.
>Solution :
Try changing E:E to E2:E
={ "EventStartDate"; arrayformula(iferror(VLOOKUP(E2:E,A2:B,2,False))) }
and see if that works?