Forum Discussion
Solved
Help in lookup functions
I have simple table here which will be large one later with huge data. My question is i want to make function in the selected cell to search all table for specifc value and return corresponding data i...
That could be
=IF( MAX( ($C$2:$G$5=$H2)*( ROW($B$2:$B$5)-ROW($B$1) ) ) = 0, "no such", INDEX( $B$2:$B$5, MAX( ($C$2:$G$5=$H2)*(ROW($B$2:$B$5)-ROW($B$1) ) ) ) )
Here is a sample file
I want to design an formla in ??????? Cell
That read the value in h2 and search for it in columns c,d,e,f,g and return the corresponding value from coulmn B. That is it i want to search the value in multiple coulmns and return one corresponding value
I want to design an formla in ??????? Cell
That read the value in h2 and search for it in columns c,d,e,f,g and return the corresponding value from coulmn B. That is it i want to search the value in multiple coulmns and return one corresponding value
That could be
=IF( MAX( ($C$2:$G$5=$H2)*( ROW($B$2:$B$5)-ROW($B$1) ) ) = 0,
"no such",
INDEX( $B$2:$B$5, MAX( ($C$2:$G$5=$H2)*(ROW($B$2:$B$5)-ROW($B$1) ) ) ) )- I worked for me thank u very much. I used nested xlooup function too. They now both work thanks for the idea.
Mahmoudali , you are welcome
- Please can we do this formula on coulmns not just cells