Nov 17 2021 06:25 AM
Nov 17 2021 06:36 AM
Nov 17 2021 11:02 AM
Nov 17 2021 12:50 PM
Could you please illustrate with sample, file, not with screenshot?
Nov 17 2021 03:30 PM
Nov 18 2021 01:46 AM
SolutionThat 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) ) ) ) )
Nov 18 2021 06:40 AM
Nov 18 2021 07:26 PM
Apr 24 2024 07:04 PM
You can see how to solve the problem at: hlookup trong excel
Nov 18 2021 01:46 AM
SolutionThat 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) ) ) ) )