Forum Discussion
return a value that satisfying two conditions
nidhiachhaa9 thank you for your help so my table A is like that (with many rows)
for example to get 1 as result in table A i had to search the value according to (6MV & 20°) in table B
so i want to make the action of getting the right data automatic but i dont know how?
Thanks alot 🙂
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 B