Search a Value

[carl1935]

Hello, 

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]

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

[#3]

Thanks @JKPieterse for the reply but is not sorted.