Forum Discussion
return a value that satisfying two conditions
mathetesthank you for your responds,
this a template file of what i am doing. the purpose is to find how i can get the right value from the table B and put it in the table A. as you can see at the moment it is easy but if i started to creat many rows with different energy and angle , i will need a fuch to make it automatic and eiser for the user of my futur file.
Thank you for your help.
May I offer some feedback? Whoever created this spreadsheet--you or somebody else--spent far too much time on making it look pretty. I have nothing against beauty--the use of colors and formatting to make things stand out--but it makes for far greater usefulness if one FIRST concentrates on getting the functionality that is needed.
In your case, for example, that range of cells from I9 to I12 is made to look as if it's a single cell, but it isn't. It's four separate cells that have been merged into one. Great for looks; but it interferes with functionality.
Could I therefore suggest you step back and create a simpler layout of what you really need--we can make it prettier later--with rows of single cells and single columns. It's also not altogether clear what the relationship is between the parameters sheet and tables A and B... And please, for the sake of testing, include not just a basic template with one or two sets of data; add more representative data so we can work with it.
What you're wanting to do is, I am confident, relatively easy with Excel's many ways to parse tables of data, but we need to work with well-defined tables at the start.
- Thank you alot for your feedback , the fact is , at the begining of my project i had a cetain look to give back so it is not really a choice however it is not a prob because i can use only one of these cells and results would still correct.
i tried to send this template to give only an idea of what i am doing but in fact the file excel is much bigger then this and so far i reached the goal of the project, the second step now is to make my file easy use and that by automatizing the choice of the right data in table BAs I said, I'm not opposed to making a spreadsheet look nice. But work on that AFTER you've gotten the functionality you need. In sales, people often talk about the sizzle or the steak, with the cynical point "If you don't have a good steak, then sell the sizzle." In spreadsheet design, all too often, I see people devote far too much attention to the sizzle before getting the steak. By all means, make it pretty; first make it work.
With that in mind, please send the whole file, the bigger one...or at least a more representative one. A template does just what you've said--"give an idea"--but not much more. You want to have the bigger project more automated, and the template per se puts emphasis on appearance over functionality.
So please send a more complete file, with a more complete definition of how the parameters (or criteria) affect the selection of the data to appear. As has already been said in this thread, there are various ways within Excel to retrieve data based on criteria. VLOOKUP is the most basic. More recently there are functions like XLOOKUP and FILTER that are even more powerful. Here's a good resource if you want to research those on your own. https://exceljet.net/excel-functions/excel-xlookup-function
I appreciate your advices , i completely understand your point of view, it is my first experience with Excel and the purpuse was to understand some mathematicals problrms which are related to the medical field , thats why i spent much time to understand that and give solutions so at this point i am doing well with and the next step is to present correctly my work in Excel.
here bellow you will find another template with much details.
Again i really appreciat your help and i hope it is going to be clear now.