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.
Bump no response
ARRAY formula in Y4
To enter ARRAY formula
Please Login or Register to view this content.
Copy and paste the formula in cell
Press F2
Press Ctrl+Shift+Enter together
Excel covers the formula with {}.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
This normal formula also works
Please Login or Register to view this content.
Another option
=XLOOKUP(U4,FILTER(C3:R35,A3:A35=T4),C2:R2,"",1)
Fantastic!!. Thanks
If problem is solved mark the thread solved.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks