I can't figure what part of my excel formula is missing to where it allows it drag down to so many cells before it gives me a N/A code. I have attached screenshots.

Transcribed Image Text:

Home Insert Function fx G2 5699 A WN A 1 tweet_id 7 AutoSave Insert Draw AutoSum v Recently Used v Financial KI DI 2 5.67588E+17 neutral 3 5.6759E+17 negative 4 5.67591E+17 negative 5.67592E+17 negative 5.67594E+17 negative 5.67595E+17 negative 5.67596E+17 negative 8 9 5.67614E+17 negative 10 5.67617E+17 negative 11 5.67617E+17 negative 12 5.67623E+17 negative 13 5.67627E+17 negative 14 5.6763E+17 negative 15 5.67634E+17 neutral 16 5.67643E+17 neutral 17 5.67655E+17 positive 18 5.67663E+17 negative 19 5.67664E+17 negative 20 5.67667E+17 neutral 21 22 23 24 5.67671E+17 unknown 5.67672E+17 positive Page Layout Logical v Text v Date & Time 5.67676E+17 negative 5.67677E+17 negative C Formulas 1 1 Can't Tell 1 Late Flight 1 Late Flight 1 Customer Serv 1 Bad Flight 1 Late Flight 1 Customer Serv 1 Customer Serv 1 Customer Serv 0.6337 Flight Booking 1 Bad Flight 1 Customer Serv 1 1 1 1 Lost Luggage 1 Late Flight 1 1 Customer Serv 1 1 Late Flight 1 Customer Serv Twitter Data from Wayne Enterpr Ready i Accessibility: Good to go V V V Data Name Manager fx =LOOKUP(@F:F, 'Twitter Data Dictionary Bruce'! F3:F8, Twitter Data Dictionary Bruce'! G3:G8) B D E F I J airline_sentir airline_sentir negative reasc negative reasc airline H airline_sentir name JetBlueNews nesi_1992 negative Delta CPoutloud brenduch 0.6503 Delta 0.346 United 1 United 0.3451 Southwest 0.6707 United 1 United 0.3545 United 1 Southwest 0.6797 United 0.6337 United 0.3611 United 0.6752 United United US Airways Southwest 1 United 0.6605 Southwest DAT 325 Twitter Student Data Delta 1 US Airways Delta Review View Define Name Use in Formula v Create from Selection DL01 DL01 UNO1 UN01 G #N/A #N/A #N/A #N/A #N/A Developer >>> 0.7098 United 0.6364 Southwest Twitter Data Dictionary Bruce Duonana Trace Precedents Vfx A Trace Dependents Show Error Watch Remove Arrows Formulas Checking Window VahidESQ brenduch CRomerDome JustOGG mrshossruns feliciastoler markhlyon DBsView On Things Ijsbrooks gwaki ashenfaced rjp1208 Tell me hannahtorney followkashyap British AirNews sevnthstar twinkletaters Mi Kasuga Working Wify Example Sou + Comments Formula Builder Show All Functions LOOKUP Lookup_value = "Delta" @F:F Result: "DL01" BI Share Calculation Options Lookup_vector = {"American"; "Delta"; "South... 'Twitter Data Dictionary Bruce'!F3:F8 Result_vector = {"AA01";"DL01","SW01"; "UN... 'Twitter Data Dictionary Bruce'! G3: G8 + X %D Done 100% Home Insert Function fx G2 5699 A WN A 1 tweet_id 7 AutoSave Insert Draw AutoSum v Recently Used v Financial KI DI 2 5.67588E+17 neutral 3 5.6759E+17 negative 4 5.67591E+17 negative 5.67592E+17 negative 5.67594E+17 negative 5.67595E+17 negative 5.67596E+17 negative 8 9 5.67614E+17 negative 10 5.67617E+17 negative 11 5.67617E+17 negative 12 5.67623E+17 negative 13 5.67627E+17 negative 14 5.6763E+17 negative 15 5.67634E+17 neutral 16 5.67643E+17 neutral 17 5.67655E+17 positive 18 5.67663E+17 negative 19 5.67664E+17 negative 20 5.67667E+17 neutral 21 22 23 24 5.67671E+17 unknown 5.67672E+17 positive Page Layout Logical v Text v Date & Time 5.67676E+17 negative 5.67677E+17 negative C Formulas 1 1 Can't Tell 1 Late Flight 1 Late Flight 1 Customer Serv 1 Bad Flight 1 Late Flight 1 Customer Serv 1 Customer Serv 1 Customer Serv 0.6337 Flight Booking 1 Bad Flight 1 Customer Serv 1 1 1 1 Lost Luggage 1 Late Flight 1 1 Customer Serv 1 1 Late Flight 1 Customer Serv Twitter Data from Wayne Enterpr Ready i Accessibility: Good to go V V V Data Name Manager fx =LOOKUP(@F:F, 'Twitter Data Dictionary Bruce'! F3:F8, Twitter Data Dictionary Bruce'! G3:G8) B D E F I J airline_sentir airline_sentir negative reasc negative reasc airline H airline_sentir name JetBlueNews nesi_1992 negative Delta CPoutloud brenduch 0.6503 Delta 0.346 United 1 United 0.3451 Southwest 0.6707 United 1 United 0.3545 United 1 Southwest 0.6797 United 0.6337 United 0.3611 United 0.6752 United United US Airways Southwest 1 United 0.6605 Southwest DAT 325 Twitter Student Data Delta 1 US Airways Delta Review View Define Name Use in Formula v Create from Selection DL01 DL01 UNO1 UN01 G #N/A #N/A #N/A #N/A #N/A Developer >>> 0.7098 United 0.6364 Southwest Twitter Data Dictionary Bruce Duonana Trace Precedents Vfx A Trace Dependents Show Error Watch Remove Arrows Formulas Checking Window VahidESQ brenduch CRomerDome JustOGG mrshossruns feliciastoler markhlyon DBsView On Things Ijsbrooks gwaki ashenfaced rjp1208 Tell me hannahtorney followkashyap British AirNews sevnthstar twinkletaters Mi Kasuga Working Wify Example Sou + Comments Formula Builder Show All Functions LOOKUP Lookup_value = "Delta" @F:F Result: "DL01" BI Share Calculation Options Lookup_vector = {"American"; "Delta"; "South... 'Twitter Data Dictionary Bruce'!F3:F8 Result_vector = {"AA01";"DL01","SW01"; "UN... 'Twitter Data Dictionary Bruce'! G3: G8 + X %D Done 100%