Search a Value

Question

Hello,&nbsp;I am doing a break even point and I need to know form&nbsp;&nbsp;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&nbsp;Now the rank is 90-110&nbsp;Thanks in advance&nbsp;&nbsp;

jkpieterse · Answer

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

carl1935 · Answer

Thanks&nbsp;JKPieterse&nbsp;for the reply but is not sorted.&nbsp;

Forum Discussion

Search a Value

2 Replies

Resources