This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Array Formula not extending to rest of column

Posted on 06-05-2019 04:37 AM
Karthick_Rajave
New Member
Reply posted on --/--/---- --:-- AM

I’m not sure why, but my array formula is not working in google sheet and even when it’s working, it doesn’t extend the formula down to through the rest of the column’s cells. Where have I gone wrong?

=ARRAYFORMULA(LOOKUP(2,1/($J:$J=$J87),$S:$S))

0 14 6,447
Topic Labels
0 Likes
14 REPLIES 14
Top Labels in this Space