Forum Discussion

carl1935's avatar
carl1935
Copper Contributor
Jun 20, 2023

Search a Value

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

 

 

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 20, 2023
    If the column you are looking in is sorted, you could use an approximate lookup using the XLOOKUP function?

Resources