Single cell in a Table

[Calgary_Neil]

I have just starting working with the new excel tables, but have been working with named ranges forever. In the past each cell in the table “Rates” would be a named range, but now are in two columns, “Level” and “Area”. How do I write Rate[Area] =“West” [Level] to return a single value?

I am trying to stay away a fixed reference like Index(Rates, 3, 2, 0), but would like something like Index(Rates, ”West”, Level, 0). I wish MS had Named this table feature something else, as searches on Table bring up the old methods which I get.

 

[Calgary_Neil]

The best I have got is =INDEX( Rates[Level], XMATCH( "West", Rates[Area]) ) , Anything Better?

 

[Peter_SSs]

With XLOOKUP?

=XLOOKUP("West",Rates[Area],Rates[Level])

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

.. and also investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

 

[Calgary_Neil]

Was also looking at DGET
thanks

 

[Peter_SSs]

thanks

You're welcome.