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 cell in my table A , the hard thing is the table A has an unlimated columns and rows,
is there any functions that i can work with? i know there is recherchev() but i can't see how to use it in this prob especially that my wanted value has to satisfy two conditions.
Thank you for your help 🙂
13 Replies
- 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....
