Forum Discussion
return a value that satisfying two conditions
Hello! I am a beginner at Excel, what i am trying to do is : table A returns two conditions that table B should take in consideration to send me the good value that i will use in a certain...
Hi, Do you mean you want to use the VLOOKUP Function for multiple conditions? Please provide the Excel file to understand and solve your problem better. Thank you
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.
