Forum Discussion

wsantos's avatar
wsantos
Brass Contributor
Apr 13, 2020

suyankjain =XLOOKUP("TINA",B:B,A:A,0,0,-1)

 

suyankjain's avatar
suyankjain
Copper Contributor
Apr 13, 2020

IS THIS FORMULA IS ONLY COMPATILBLE FOR EXCEL 365 USERS?

BECUASE ITS NOT WORKING

wsantos 

  • wsantos's avatar
    wsantos
    Brass Contributor
    Apr 13, 2020

    suyankjain Not sure if you need O365, or just a new version of excel. I don't know of another way of doing this, sorry.

Resources