I have an excel sheet with pipe wall thickness schedules. I need to get the table heading (highlighted in yellow) based on T4 & U4 cell values. T4 value will be the same as any of listed values in column A. but U4 will not be. so function need to look up for the equal or next greater value and then return with respective column heading/schedule. also the greater value shall be shown in bracket. hope someone will help.
Bookmarks