Forum Discussion
Solved
Lookup for values in a column different than zero/empty
Dear all, There is a way to lookup for values in a specific column but ignore empty cells or cells with zero? For instance, I have a flow table, by product in which each line represent a differ...
As variant
with
=INDEX(Table1[Price (% Quoted)], MATCH(1, INDEX( (Table1[ID]=E3)*(Table1[Price (% Quoted)]<>0)*(Table1[Price (% Quoted)]<>""),0),0))
As variant
with
=INDEX(Table1[Price (% Quoted)], MATCH(1, INDEX( (Table1[ID]=E3)*(Table1[Price (% Quoted)]<>0)*(Table1[Price (% Quoted)]<>""),0),0))
Works perfectly. Thank you.
Inesmateus , you are welcome