Search result with two criteria

[wsaico]

I have a table called PRICES, said table has 2 drop-down columns [CITY], [CATEGORY] and column [PRICE], this last column contains prices differentiated by categories, what I want is that when selecting the CITY and CATEGORY, it returns the corresponding PRICE .

I have managed to do with VALID IF with dependent menus but I would like to know another way as well as the LOOKUP function

Thank you very much for your reply

[Joseph_Seddik · Accepted solution]

I don't personally use dependent dropdowns, because I prefer being able to control the exact behavior of the app, rather than depend on how would the app interpret a certain setup or another. But this is just a personal opinion. 

The expression you can use alternatively is:

ANY( SELECT(table[price], AND(
   [City] = [_ThisRow].[City],
   [Category] = [_ThisRow].[Category]
)))

LOOKUP() is just a wrapper for SELECT(). Please read this excellent post:

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_R... - Google Cloud Community  

[wsaico]

Thank you @Joseph_Seddik  very much, with this expression my query was solved