Hi guys,
I have data in column A & B that are related and constant. Then I have data in cells D2 & D3 that will be changing periodically.
I want cells E2 & E3 to give me a value from column B that equals the value I have in cells D2 & D3 if there is any. In case there isn't any, I want cells E2 & E3 to give me the closest bigger value from column B. For example in my workbook, D2=42, since there's no 42 in column B, E2 will be equal to 52. D3=61, since there is 61 in column B, E3 will be equal to 61.
I also want cells F2 & F3 to give me the respective values from column A that are related to the values chosen from column B. In my workbook, 52 is related to 17 and 61 is related to 19.
What formulas can I use for cells E2, E3, F2 and F3?
Thanks for your help.
Bookmarks