Search a Value

Copper Contributor


I am doing a break even point and I need to know form  what percentage of sales the company is profitable. I cant use LOOKUP because the number is not in the column. Have you got any idea??

Sintaxis would be: lookup in C14:C6014 any porcentage that make G14:G6014, = or superior and 0 

Now the rank is 90-110 

Thanks in advance




2 Replies
If the column you are looking in is sorted, you could use an approximate lookup using the XLOOKUP function?

Thanks @Jan Karel Pieterse for the reply but is not sorted.