Hi,
My knowledge of excel is very basic so any help will be appreciated
I am trying to do a lookup to display all matching values in the cells H2 / I2 / J2 cells to the columns highlighted green in my spreadsheet. Is there any way of doing this?
Note: Cross-posted at https://www.mrexcel.com/board/thread...lines.1178628/ --6SJ
Last edited by 6StringJazzer; 08-08-2021 at 01:23 PM. Reason: xpost
Why not just use a slicer for each of the columns and filter using that?
Last edited by AliGW; 08-08-2021 at 12:11 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
That`s perfect thanks, but is there any way of filtering on both the highlighted green sections not just the columns that begin with "shaft"?
As you can see the values repeat in both the "base" and "shaft" sections
Thankyou for your time
Yes - just add extra slicers. However, you didn't show that in your opening post or in your workbook, so I'm not quite sure what you're after.
If this isn't what you want then you are going to have to give more detail.
Hi,
Basically the values stated (BASE DIA / BASE THK / BASE GRADE & SHAFT DIAMETER / SHAFT THICKNESS / SHAFT GRADE) are all steel parameters.
I want to be able to filter from a large range of data which steel is being used. the diameters / thickness / grade may occur in both the BASE and SHAFT section.
So I am trying to do a filter to show just certain parameters. for example I just want to see orders that contain 139 / 3.0 / S275 etc...
Thanks again
OK - mock up what you want, please, using a small set of sample data. Anything I do will be just guesswork - give us something concrete to work with that shows what you are aiming to achieve.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
Because you have just a few posts I have added it for you. For next time please take the time to review our rules. There aren't many, and they are all important.
Hi,
Hopefully, the attached will clarify
As seen in the first section a reduced set of data
In the second section, you can see where I have specified what I want to find and then the set of orders that contain this data
Hope it helps
This will display the orders, although not in the same sequence as shown in rows 29:51.
The formula for the order number is:Formula:
Please Login or Register to view this content.
The formula for the rest of the columns is:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks