Forum Discussion
return a value that satisfying two conditions
What isn't clear to me is how all the different sheets relate to one another. Nor is it clear what you're still working to resolve. You clearly have some functioning formulas in there--because you're working in French, a language I don't understand--I'm limited to begin with in trying to decipher what's going on.
So for me--and I suspect for others--to be able to help, this workbook is a good start (Thank you!) but we would need a much clearer description of what specific elements of information you are seeking to have retrieved, from what other part of the workbook, based on what criteria (and where those criteria are to be found).
So the work is about determining the thickness of a radiotherapy room.
so the workbook Table 1 , tabla 2 Table 3 are not related to each other , all of them are related to the first notework where i do have my parameters which is automated and also Table 1, table
2 Table 3 are related to the workbook DataBase and this what i am trying to automate right now .
In the notework DataBase i wrote some remarks of what i am trying to do 🙂
those columns are filed in by hand because i am the one who created the Excel so i know how to get the right data , but imagine for a certain user the situation it would be hard for him so what i am willing to do is :
let the user choose the angle and the enegy than the DataBse send the right value to the right column .So what you would need to do for "a certain user" is to explain in detail (1) where that user would find the angle and energy values, and then (2) how those values would be used to retrieve (look up) and then (3) "send the right value to the right column".....that's all I'm asking for too. Another way to say it, you know how to navigate around your tables; you need to take me (or that hypothetical new user) by the hand and show us both what you are taking for granted.
- Yes those columns are filed in by hand because i am the one who created the Excel so i know how to get the right data , but imagine for a certain user the situation it would be hard for him so what i am willing to do is :
let the user choose the angle and the enegy than the DataBse send the right value to the right column .
I undestand that it is hard for you to help me because you dont fully understan what i am hoping to do .
Anyway thank you alot you really tried to helped me and i appreciate that. 🙂 i am sorry i am a french speaker and thats explain my bad english
🙂
Truly, your English is not a problem at all.
So the work is about determining the thickness of a radiotherapy room.
so the workbook Table 1 , tabla 2 Table 3 are not related to each other , all of them are related to the first notework where i do have my parameters which is automated and also Table 1, table
2 Table 3 are related to the workbook DataBase and this what i am trying to automate right now .
In the notework DataBase i wrote some remarks of what i am trying to doI see those brief remarks, but don't fully comprehend them (that is, I'm not able to take what you've written and think about them in the logical terms that are needed to come up with the formulas). Also, you have those columns in Table A3 and A2 filled in...so what is it that you're missing?