index match with named ranges in google sheets?

[RaviWildcat]

Hi Everyone -

I love using named ranges in excel that I can run an index match against for look ups.

For example, assuming I have a sales table with a column for someone's name and col 4 containing the sales amount.

If Iwant to lookup how many sales Greg Brady made, I can create a formula like this: index(sales, match("Greg Brady",sales[name],0),4)

Can I do something similar in google sheets? I've tried creating a named range but my index function doesn't work. I've looked briefly on google but haven't found anything addressing this question

Thanks,
Ravi