I have got two columns, let say column A and B. In Column A, I have P/L Value. In column B, i have got percentage corresponding to each value. Now i need to find out a way to pick the P/L value whose percentage value is 5%. Please note, Column B can containg 5% value or it may not. It can have value between 4 and 5%, for example. In that case, I need to calculate P/L value for 5%. Please help.
You possibly want the
It supports "range" lookups, which will find a match in the case that exactly 5% is not given in the lookup column.
Take the following in a sheet:
I think a
It works by offsetting from cell A1 by:
And the range you need to return is 1 cell high and 1 cell wide.