Forum Discussion
Need help with Excel's equivalent to some Google Sheets functions
Hi . . . I'm looking for Excel's equivalent (or workaround) to some Google Sheets functions: In Google Sheets, VLOOKUP can be written like this: =VLOOKUP(A3,{Definitions!Z4:Z1000,Definitions...
To your first question:
=INDEX(Definitions!C4:C1000,MATCH(A3,Definitions!Z4:Z1000,0))
Your second question can be done using Advanced filter, not with a formula .
Unless you are on Office 365, insider fast ring with the very latest new features released just this month. Then you can use the new Filter function.
=INDEX(Definitions!C4:C1000,MATCH(A3,Definitions!Z4:Z1000,0))
Your second question can be done using Advanced filter, not with a formula .
Unless you are on Office 365, insider fast ring with the very latest new features released just this month. Then you can use the new Filter function.