Forum Discussion
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?? ...
If the column you are looking in is sorted, you could use an approximate lookup using the XLOOKUP function?
Thanks JKPieterse for the reply but is not sorted.