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 🙂
- nidhiachhaa9 asked if you could supply the actual Excel file. Images are not at all as helpful as the actual file. But seeing the actual spreadsheet, the source data and the desired result...what you've tried so far...If you have to create a modified version (or a mock-up) to conceal confidential information, please do that. But please give us an actual Excel file....
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.
